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.