title: how to stored procedures with bigquery?
body: <p>I want to replace text and column name by stored procedures and it didn't change the value.</p>
  <pre><code> CREATE OR REPLACE PROCEDURE dataset.test_pivot(name STRING)
   BEGIN
   
   SELECT 'name',* FROM
   (
      SELECT 
     name
     FROM `dataset.mytable`
   )
   PIVOT
   (
      count(*) AS N
      FOR name in ('P1', 'P2', 'P3', 'P4', 'P5', 'P6', 'P7', 'P8', 'P9', 'P10')
   );
   END
   
   
   CALL dataset.test_pivot(inte_acedemic);
  </code></pre>
  <p>The result is</p>
  <p><a href="https://i.stack.imgur.com/u6PKm.png" rel="nofollow noreferrer">https://i.stack.imgur.com/u6PKm.png</a></p>
  <p>I want replace <code>name</code> with <code>inte_acedemic</code>.  Many thanks!</p>