Google BigQuery is an enterprise data warehouse for large-scale data analytics. You can connect Quantive to any table in a BigQuery dataset and create a Quantive entity based on it.

Quantive supports two ways of integrating with Google BigQuery – using a Quantive-provided service account or using a service account owned by the user.

Quantive uses a service account with OAuth 2.0 authentication/authorization flow. Before you establish a connection to your BigQuery data set you need to make sure that the Quantive Service Account for Google API has been added to your project and assigned the necessary permissions. We recommend that you use a custom role and assign this role to the service account.

Creating a custom role in the Google Cloud Platform

To create a custom role log in to your Google Cloud Platform account and navigate to the Console. Select the project where you want to create the custom role, then from the menu choose IAM & Admin > Roles. 

1. Click the Create Role button
​

2. Fill in details for the role you will be creating.
​

3. Add the following permissions:

4. Click the Create button.

In the IAM & Admin management console go to the IAM section. Click on the Add button to add the Quantive Service account, then use [email protected] as the user email. Finally set the custom role created earlier.

In the case of a user-provided Google service account, you need to download the key in the form of a JSON file from the Google Cloud Developer website. To do it, you have to go to the Google Cloud Platform > Service Accounts > select your service account.

Then go to Keys > Add key > Create new Key.

Select JSON and click Create. This will download the JSON file to your PC.

Enter the necessary information to connect to your BigQuery dataset.

Click on the Connect button. If Quantive has been granted the necessary permissions to read data from BigQuery you will be able to choose the table you want to pull data from. In this example, we will use a table named employees.

Select the table you want. Then choose its sync schedule.

Enter the necessary information to connect to your BigQuery dataset.

Click on the Connect button. If Quantive has been granted the necessary permissions to read data from BigQuery you will be able to choose the table you want to pull data from. In this example, we will use a table named employees.