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?
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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With