Create a ticket Your tickets
Welcome
Login
  1. Home
  2. Solution home
  3. Data warehouses and cloud storage
  4. BigQuery
Open navigation

How to configure a BigQuery destination on the Supermetrics Team Site

Supermetrics Support Site Team
Modified on: Fri, 20 Jan, 2023 at 10:36 AM

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


1. Set up Google Cloud account and project

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.

  1. Create a new Google Cloud account.
  2. Create a new Google Cloud project.
  3. Enable billing for the Google Cloud project.
2. Enable BigQuery API

Follow these instructions to enable the BigQuery API.

3. Create a Google Cloud service account

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.

4. Generate and download service account key

This is the key you use to authenticate your connection to BigQuery.

  1. Navigate to the Service Accounts page in Google Cloud IAM. Click the email address for the service account that you created.
  2. Click Keys.
  3. Click Add key, and then click Create new key.
  4. Click Create. A JSON key file will be downloaded to your computer.
  5. Click Close.
5. Create a dataset

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

  1. Log in to the Team Site.
  2. go to Destinations.
  3. Click Create destination.
  4. Select BigQuery.
  5. In the Display name field, give a name to the destination you want to connect to.
  6. In the Dataset name field, give the name of a previously created dataset you want Supermetrics to write to.
  7. In the Auth key field, enter the service account key for your Google Cloud service account.
    1. Open your downloaded JSON key file in a text editor.
    2. Copy the text from the key.
    3. Paste the text to the Auth key field.
  8. Click Test to check that the connection works.
  9. Click Save.

Did you find it helpful? Yes No

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