Open navigation

About the Query SQL field and SQL dialect

When querying data from your BigQuery instance to Google Sheets or Looker Studio with our Google BigQuery data source connector, you might encounter issues with your queries. 

By default, the connector uses legacy SQL. If your query isn't working as expected, set the dialect to standard SQL by adding the #standardSQL declaration on the first row of your SQL.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.