GCP - BigQuery Export Setup

Overview

The BigQuery Export Integration provided by Indicative allows customers to easily export their raw Indicative data to BigQuery for further analysis via a SQL interface.

The purpose of this document is to provide an overview of how Indicative loads raw data into BigQuery and what customers need to provide to configure and maintain the integration.

This document is intended for customers who are familiar with both Google BigQuery and the Indicative data model.  

Getting Started

In order to use the BigQuery Export Integration for Indicative, the customer must provide programmatic BigQuery access to the Indicative Platform. The customer is required to grant dataViewer BigQuery access to Indicative.

In order to perform the following steps you must have administrative access to the BigQuery Console as well as your BigQuery database.

Create a BigQuery Dataset (Optional)

  1. Open the BigQuery web UI in the GCP Console.

  2. In the navigation panel, in the Resources section, select your project.

  3. On the right side of the window, in the details panel, click Create dataset.

  4. On the Create dataset page:

    • For Dataset ID, enter a unique dataset name.
    • (Optional) For Data location, choose a geographic location for the dataset. If you leave the value set to Default, the location is set to US. After a dataset is created, the location can't be changed.

    • For Default table expiration, choose one of the following options:

      • Never: (Default) Tables created in the dataset are never automatically deleted. You must delete them manually.
      • Number of days after table creation: This value determines when a newly created table in the dataset is deleted. This value is applied if you do not set a table expiration when the table is created.
    • Click Create dataset.

Share Your Dataset with Indicative

1. In the menu panel along the left side of your screen, under Resources, click on the triangle to the left of your project name to expand the view. This will display the available datasets.
 
2. Select a dataset from Resources, then click Share dataset near the right side of the window.
 
share_dataset.png
 
3. In the Share dataset panel, in the Dataset permissions tab, click Add members.
 
4. In the Add members panel, enter "integrations@indicative-988.iam.gserviceaccount.com" into the New members text box.
 
5. For Select a role, select BigQuery and choose bigquery.dataViewer.
 
6. Click Done.
 
7. Contact your account manager once you have granted Indicative 'bigquery.dataViewer' access to ensure that the connection is properly configured.
1 users found this helpful