How do I run a standard SQL query without breaking BigQuery Connector for Excel?

I want to run the following query. It is valid and works in the web ui

SELECT * FROM `option-optimizer.cme.3months_euro_dollar_future`
where date = '2017-09-01'


but it doesn't work when I run it through the BigQuery Connector for Excel. It doesn't seem to recognize the standard SQL format. Here's the error I get.

Request failed: Error. Unable to execute query. 400
"code": 400,
"errors": [

"domain": "global",
"location": "`option-optimizer:cme.3months_euro_dollar_future`",
"locationType": "other",
"message": "Invalid table name: `option-optimizer:cme.3months_euro_dollar_future`n[Try using standard SQL (https://cloud.google.com/bigquery/docs/reference/standard-sql/enabling-standard-sql)].",
"reason": "invalid"

],
"message": "Invalid table name: `option-optimizer:cme.3months_euro_dollar_future`n[Try using standard SQL (https://cloud.google.com/bigquery/docs/reference/standard-sql/enabling-standard-sql)]."



In addition to above error, I think the date filter would also break.

1 Answer
1

To run queries using standard SQL, prefix your query with the following line:

#standardSQL


for example:

#standardSQL
SELECT * FROM `option-optimizer.cme.3months_euro_dollar_future`
where date = '2017-09-01'


By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.