Supermetrics Support Forum

Invalid Table Name: Try Using Standard SQL (Sheets)

This guide applies to the following error that may appear in the Google Sheets Google BigQuery connector:

Invalid table name: `supermetrics-demo.xxxx.BINGADS_GEO_20190407` [Try using standard SQL (https://cloud.google.com/bigquery/docs/reference/standard-sql/enabling-standard-sql)].


As noted in the URL from the error text, if you don't explicitly query it as standard SQL, it will run as legacy. To fix this, include at the top of your SQL query the text:

#standardSQL


Orange box highlights the SQL query line that contains "#standardSQL" to enforce that it runs as standard

Did you find it helpful? Yes No

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