I need to pass column names as parameters in standard SQL Bigquery so that I do not need to hard code the column names. How can I do that? I need to do something like :
@column_name = "Origin";
SELECT @column_name FROM table
Asked
Active
Viewed 3,793 times
1
Ishita Srivastava
- 83
- 2
- 9
-
if BigQuery is anything like T-SQL then `DECLARE` a parameter and then `SET` it to your column name – David Andrei Ned Mar 21 '17 at 10:52
-
keywords like DECLARE are not accepted by BigQuery – Ishita Srivastava Mar 21 '17 at 10:53
-
BigQuery uses standard SQL 2011 according to documentation – Ishita Srivastava Mar 21 '17 at 10:54
-
The relevant [feature request is in the issue tracker](https://issuetracker.google.com/issues/35905569). – Elliott Brossard Mar 21 '17 at 11:38
-
Note that even with query parameters, however, you would not be able to pass a parameter in place of a column name, just in place of an expression. – Elliott Brossard Mar 21 '17 at 11:39
-
Will it not be possible to pass column name as parameter in SELECT statement of SQL Bigquery – Ishita Srivastava Mar 21 '17 at 12:03
-
It will not be, because that defeats the point of query parameters, which help prevent against SQL injection. – Elliott Brossard Mar 21 '17 at 12:36
1 Answers
0
As of April 2015, the answer seems to be:
There are no 'variables' to be set in BigQuery, but you could add a feature request.
From the same thread, it seems you can use Datalab to use Python variables with BigQuery.
Also, see this thread about using SQL API.
Community
- 1
- 1
David Andrei Ned
- 799
- 1
- 11
- 28
-
As of Dec 2016, bigquery standard SQL supports parameterized queries: https://cloud.google.com/bigquery/docs/release-notes#December_22_2016 – xibalba1 Apr 21 '20 at 15:37