CODEWITHSUNDEEP
sqlgoogle-bigquery
dina
dina

Reputation: 4289

how to set named parameter on bigquery query

I am trying to use named parameters in my query on bigquery.

@val '123';
SELECT *
FROM [project_id:my_dataset.my_table] 
where name=@val

I get

Encountered " <MAX_TOKEN_VAL> "R "" at line 1, column 2. Was expecting: <EOF>

is there any way to set named parameters on biquery?

Upvotes: 14

Views: 29873

Answers (1)

Elliott Brossard
Elliott Brossard

Reputation: 33705

Named parameters are supported in BigQuery only through the API using standard SQL, not the web UI. You can read about them in the section on Running parameterized queries. If you are interested in web UI support for query parameters, you can star the feature request on the issue tracker.

Upvotes: 19

Related Questions