Setting Up the Google Big Query Integration

The Google Big Query integration allows you to automate the export of your Dialog Insight project to your GBQ project. This makes the transfer easier for your complementary and behavioral data that are generated by DI. This way, you can easily exploit and analyze this data in your GBQ warehouse. 

Prerequisites

1. Create a Google Cloud account and a Google Big Query project
2. Create a Google Cloud service account (dedicated to a connection with DI). It is recommended to create a custom role with the following permissions :
   • bigquery.datasets.create
   • bigquery.jobs.create

Step 1: Connect the GBQ Project

First, find your GBQ project ID:

In DI, follow the access path and select Google Big Query in the integration list. 

Enter your GBQ project ID:

Upload the JSON file (exported from GBQ) that contains the account service keys:

Étape 2: Configuring the Export

For the export, you can use a log export or an automated export (or both). 

Option 1: Log Export
Using log export will export all the tables from your project. When you export logs, a (non-editable) dataset is created in GBQ. 

You must choose Google Big Query as the destination:

If you want to export all data starting from the creation of your DI project, check Export all data on the next run*:Otherwise, you can specify the period in days to include in the next export (90 days as default).

*Remember to uncheck the option after the first export. Otherwise, every export will send the entirety of the data, which will impact the performance.

When you are done configuring a log export, remember to click Save at the bottom of the page.

Then, it is recommended to manually launch the first export so it is processed now (you must check Export all data on the next run). Click Activate:

Go to the History tab, select a task and click Launch now:→ See the complete procedure for log export

Option 2: Automated Export
It's possible to configure several automated exports (unlike a log export, there is no limit). An automated export allows the export of only one object (a table) at a time. You must to configure several exports if you want to export several objects.

Select Google Big Query as the destination:

When you are done configuring an automated export, remember to click Save at the bottom of the page.

After, it's recommended to manually launch the first export so it is processed now.→ See the complete procedure for automated export