This guide contains all permissions and requirements for connecting your Google BigQuery (Legacy) data to Supermetrics.
Note
We strongly recommend that all new and existing users migrate to the new Google BigQuery connector, as it is our focus for future enhancements and development.
The Google BigQuery (Legacy) data source connector is available only in Google Sheets and Looker Studio.
Required permissions
You need BigQuery Data Viewer and BigQuery User role levels for the Dataset, and the BigQuery User role for the Project.
Google has limited the availability of its access credentials to 16 hours. Adding Supermetrics as a trusted app in the Google admin console can enable scheduled query refreshes and help you avoid daily reauthentication. Learn how to add Supermetrics as a trusted app.
Google BigQuery field list types
Simplified field list: Shows each unique field name just once, if it's present in multiple tables.
Full-field list: Shows all columns from your tables in BigQuery.
Simplified list: With join fields only — shows only the fields that are available for multiple data sources.
Connection instructions
When connecting to Google BigQuery (Legacy), you need to Log in to Google and select the accounts to pull data from when prompted.
Select the Google BigQuery (Legacy) data source in the data destination.
If prompted, choose to make this connection shared or private.
Click Sign in with Google.
Sign in with the Google Account you use with this data source. This doesn't have to be the same as the Google Account you use with Supermetrics.
Click Allow, and click Continue.
Select all access scopes and click Allow. Failure to select all may result in the data source not functioning correctly.
In your data destination, select the accounts to pull data from.
You can connect to Google BigQuery (Legacy) from these destinations:
Looker Studio: How to connect data sources to Looker Studio