In this article

A guide to setting up and using Google's BigQuery for Permutive Routing.

Create a Google Cloud Platform account

If you do not already have one, you will need to create a Google Cloud Platform (GCP) project.

Google Cloud offers a free trial account that includes a $300 credit to use with any Google Cloud Platform products during the first 12 months and free usage up to specified quotas on selecting their cloud products. In particular, this account provides 10 GB of BigQuery storage and 1 TB of querying per month for free.

Create a Google Cloud Platform project and enable BigQuery

You will want to create a new project within your Google Cloud Platform account to hold your data warehouse and enable the BigQuery product on this project.

1. Open the Google Cloud Console.

2. If you don’t already have one, create a project for your Google Cloud account by heading to the Manage Resources page and clicking Create Project.

3. In the New Project window, enter a project name, select a billing account, and then click Create. BigQuery is enabled by default in new projects.

4.If you have an existing Google Cloud project, you will want to check that BigQuery is enabled by navigating to the Enable API section and selecting the project you wish to enable the BigQuery API on.

5. Ensure the dataset is not created manually

Note: You do not need to manually create a dataset for the Routing destination. This is taken care of automatically by our system during the setup process. The only manual step required will be to grant permissions to our service account explained later on in this document.

Creating your BigQuery Router

Once your Google Cloud project is set up, please contact support@permutive.com to enable the Router in your Permutive Project.

Note: We expect the Router to be enabled in the UI within 48 hours.

When the Routing product is enabled for your account, you will see it appear in the product navigation bar in the Permutive Dashboard

Add a new BigQuery Router

To add the Big Query Router:

1. Navigate to the Routing tab and click on the Add Integration button.

2. Select the BigQuery destination type

 

Configure your BigQuery destination

You will need to configure your BigQuery Router by entering some details for the BigQuery project you just created in the Google Cloud Project.

 

Configure	Description	Documentation
Project	The project ID for the BigQuery project was created in your Google Cloud Platform account. This is the project that will house the BigQuery instance.	Link
Dataset	The name of the BigQuery dataset that will contain the event tables. This dataset should have a unique name and not already exist.	Link
Location	The geographical location that the data will be stored in. This can either be the US for customers in the US or the EU for customers in EMEA.	Link

 

Authorize access for your BigQuery Router

Permutive generates a unique service account that is used to interact with your new BigQuery routing instance. You must authorize this service account to have the BigQuery User role for your BigQuery instance.

On completion of the previous step, you will have been prompted to authorize access for your BigQuery Router in the dashboard UI.

 

The Permutive service account email ID needs to be assigned the BigQuery User role:

Account: routing-customer-068225a32a6f4@permutive-routing-production.iam.gserviceaccount.com

You can assign access through the Google Cloud Platform Console by navigating to the IAM tab.

Note: If you have manually created the dataset, you must assign the Permutive service account the role of BigQuery Data Owner to the created dataset. 

Notify Permutive once the service account is granted access

Once you have granted access to BigQuery, you need to confirm this with Permutive by clicking the button highlighted below.

Warning: This button should only be clicked once you have granted access to BigQuery in the Google Cloud Platform Console. If access is granted incorrectly, or not at all, the Router setup will fail, and you will need to start the configuration of your Router from the beginning.

BigQuery Router setup completion

After you have confirmed access has been granted, the status of your BigQuery destination will transition to Running to show the router has been successfully set up. This will take a couple of minutes to display.

 

If the status transitions to Failed then please contact support@permutive.com to further assist.