Availability
This feature is currently in closed beta. Get in touch with our support team if you have any questions.
Create BigQuery queries directly on the Supermetrics Team Site. This method supports 2 years of backfills and more regions than our classic BigQuery destination, and uses Standard tables instead of Sharded tables.
An efficient data storage format means that you'll see faster results and larger query sizes when working with BigQuery in the Team Site than you would with our classic destination.
Before you begin
To use the Team Site version of BigQuery, you need:
- A Google Cloud account and a Google Cloud project with billing enabled
- BigQuery API enabled
- A Google Cloud service account
- A service account key
- A dataset to connect to
If you haven’t used Google Cloud and created a project before, you have to create a new Google Cloud account and a Google Cloud project, as well as enable billing for the project.
Follow these instructions to enable the BigQuery API.
You need to create a Google Cloud service account to use BigQuery from the Team Site. Follow these instructions to create the service account.
When setting up access permissions for your service account, select the BigQuery Admin role.
This is the key you use to authenticate your connection to BigQuery.
- Navigate to the Service Accounts page in Google Cloud IAM. Click the email address for the service account that you created.
- Click Keys.
- Click Add key, and then click Create new key.
- Click Create. A JSON key file will be downloaded to your computer.
- Click Close.
You need to create a dataset in BigQuery for your queries to connect to from the Team Site. Follow these instructions to create a dataset in BigQuery.
Instructions
- Log in to the Team Site.
- go to Destinations.
- Click Create destination.
- Select BigQuery.
- In the Display name field, give a name to the destination you want to connect to.
- In the Dataset name field, give the name of a previously created dataset you want Supermetrics to write to.
- In the Auth key field, enter the service account key for your Google Cloud service account.
- Open your downloaded JSON key file in a text editor.
- Copy the text from the key.
- Paste the text to the Auth key field.
- Click Test to check that the connection works.
- Click Save.