Open navigation

About BigQuery prerequisites

Before you can begin using BigQuery as a Supermetrics destination, ensure that you’ve met the prerequisites below.


Prerequisites

To use the Supermetrics Hub version of BigQuery, you need:

  • A Google Cloud account and a Google Cloud project with billing enabled
  • BigQuery API enabled
  • A custom role with permissions to create BigQuery jobs
  • A Google Cloud service account with either of the following roles:
    • Role "BigQuery Admin" for the dataset.
    • Custom role with permissions to create BigQuery jobs
  • A service account key
  • A dataset to connect to


Instructions

Step 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.
Step 2. Enable BigQuery API

Follow these instructions to enable the BigQuery API.

Step 3. Create a Google Cloud service account with admin role or custom role

Option 1: Create a Google Cloud service account with admin role

You need to create a Google Cloud service account to use BigQuery from the Supermetrics Hub. Follow these instructions to create the service account


When setting up access permissions for your service account, select the BigQuery Admin role.


Option 2: Create a Google Cloud service account with the custom role

  1. Create a custom role in the Google Cloud project with all bigquery.jobs.* permissions. Follow these instructions to create a custom role.
  2. Create a Google Cloud service account to use BigQuery from the Supermetrics Hub. Follow these instructions to create the service account.
    When setting up access permissions for your service account, select the custom role you created.
Step 4. Generate and download service account key

The service account key is used to connect Supermetrics with a specific BigQuery project and dataset.


Creating the service account key requires a Create Service Accounts (roles/iam.serviceAccountCreator) IAM role on the project.


To get the service account key, you should either:

  • Ask your administrator to grant you the Create Service Accounts (roles/iam.serviceAccountCreator) IAM role on the BigQuery project, and create the service account key yourself.
  • Ask your admin to create the service account key and share the key with you.
  • Invite your admin to the Supermetrics team, and ask the admin to create the BigQuery connection on the Destinations page on the Supermetrics Hub.


With the necessary IAM role, follow these steps to create the service account key:

  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.
Step 5. Create a dataset

You need to create a dataset in BigQuery for your queries to connect to from the Supermetrics Hub. 


If you created the Google Cloud service account with a custom role, grant the Data Owner role for the data set to the service account you created.


Follow these instructions to create a dataset in BigQuery.

More resources

Did you find it helpful? Yes No

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