This guide contains all permissions and requirements for connecting your Google BigQuery data to Supermetrics.
You can connect to data sources from the Data sources page on the Supermetrics Hub. On the Hub, you can also share an authentication link to connect to a data source you don't have direct access to.
After you connect to the data source on the Hub, you can use the data source connection in all available destinations.
Required permissions
You need a Google account with access to view and manage tables in BigQuery in Google Cloud in order to connect.
Required Google Account permissions:
- View and manage your tables, datasets and jobs in Google BigQuery
- See the email address for your Google Account
You also need to get your table ID and identify the date column in your table.
To obtain your table ID:
- Identify the BigQuery table you wish to connect to in the Google Cloud console.
In the left-hand Explorer section, click on the three dots next to the table.
Select Copy ID and save this for later.
To identify your date column:
- Select your table in the Google Cloud console and open the Schema tab.
- Copy the field name of the column you want to use for date range filtering.
Please note that your BigQuery table must have a DATE or DATETIME column in order to fetch data for specific date ranges.
Query types
If prompted, you need to select a query type to pull data.
- Table: Fetch data from your table in BigQuery.
Connection instructions
When connecting to Google BigQuery, you need to be logged in to your Google account.
- Select the Google BigQuery data source on the Supermetrics Hub or in the data destination.
- Insert the table ID.
- If prompted, choose to make this connection shared or private.
- Click Start.
- In your data destination, fill in the value for the Date column setting.
See detailed instructions on how to connect to a data source from the Supermetrics Hub.
You can also connect to Google BigQuery from these destinations:
- Google Sheets: How to log in to a Supermetrics data source in Google Sheets
- Looker Studio: How to connect data sources to Looker Studio
- Excel: How to connect data sources to Excel with Supermetrics
- Power BI: How to create your first Supermetrics query for Power BI
- The Supermetrics API: How to use the Query Manager
- Data warehouse and cloud storage (Hub): How to create a transfer
- BigQuery (marketplace): How to create a BigQuery (marketplace) transfer