Google BigQuery connection guide

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.

1. Create a service account:

   1. Create a service account and assign sufficient permissions for it, for example:

      1. roles/bigquery.user (project-level)

      2. roles/bigquery.dataViewer (dataset-level)

      Detailed instructions are available in Google’s documentation.

2. Create and obtain a private JSON key for the service account:

   1. In the Google Cloud console, go to the Service accounts page.

   2. Go to Service accounts and select a project.

   3. Click the email address of the service account you want to create a key for.

   4. Click the Keys tab.

   5. Click the Add key drop-down menu, then select Create new key.

   6. Select JSON as the Key type and click Create.

   7. To authenticate the connector, use the following values from the JSON file:

      1. Private key: The complete string from - - - - - BEGIN PRIVATE KEY - - - - - to - - - - - END PRIVATE KEY - - - - -\n

      2. Key ID

      3. Client email

      For more details on creating keys, refer to Google’s documentation.

1. You need to be logged in with your Google Account.

2. Select the Google BigQuery data source on the Supermetrics Hub or in the data destination.

3. Insert the table ID.

4. If prompted, choose to make this connection shared or private.

5. Click Start.

6. In your data destination, fill in the value for the Date column setting.

1. Select the Google BigQuery data source on the Supermetrics Hub or in the data destination.

2. Insert the table ID, Private key, Key ID, and Client email.

3. If prompted, choose to make this connection shared or private.

4. Click Start.

5. In your data destination, fill in the value for the Date column setting.