如何在bigquery查询中设置命名参数 [英] how to set named parameter on bigquery query

问题描述

  @val'123'; 
 
 SELECT * 
 FROM [project_id：my_dataset.my_table] 
其中name = @ val 
  

$ b

遇到< MAX_TOKEN_VAL>R在第1行第2列。期待：< / p ; EOF>

是否有任何方法可以在biquery上设置命名参数？

解决方案

只有通过API使用标准SQL ，而不是Web UI。您可以在运行参数化查询一节中阅读它们。如果您对查询参数的Web UI支持感兴趣，则可以为问题跟踪器< a>。

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.

这篇关于如何在bigquery查询中设置命名参数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！