About BigQuery prerequisites

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.

Follow these instructions to enable the BigQuery API.

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.

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.

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