Configure a Google BigQuery connection

Who can use this feature?

A connection is an authentication mechanism to allow Totango to integrate with another system. Each connector has different requirements for connection. You can reuse connections to support multiple integration jobs. 

Data warehouse integrations are a closed system; you cannot reuse data warehouse connections for other integration families. 

1. Create a GCP service account

The Google BigQuery connector is a pure database connection. It is built as a connector and an SQL query powers this connection. Learn more about Google BigQuery.

  1. In the Cloud Console, go to the Create service account key page.
  2. Select a project.
  3. From the Service account list, select Create service account.

    Service account users only have access to applications and APIs.

  4. Enter a name for the service account.
  5. From the Role list, select Project > Viewer (gives read access to resources that enable Totango connector to test the connection).
  6. Select additional Role, select BigQuery > BigQuery Data Viewer (gives view access to  datasets). 
  7. Click Done.

2. Download a Google BigQuery key file

Create a Google service account JSON key file that contains your key.

  1. From the Big Query Connector in the Cloud Console, click the Ellipses (...), and click Manage Keys.
  2. mceclip2.png
  3. Click Add Key.
  4. Choose Json, and click on Create

A file with the private key will be downloaded to your computer.

3. Create a Google BigQuery connection in Totango

In the event that your network is behind a firewall, you will need to whitelist our servers so that we may retrieve information from your data warehouse.

  1. In Totango, click Settings from the left nav.
  2. Expand Data Management > Customer Data Hub.
  3. From the list of active connectors (left), choose Data Warehouses.
  4. From the list of available connectors, hover over Google BigQuery, and click Connect (or View Integrations).
  5. Enter a name and description for the connection (e.g., Company DWH - Customer and Contacts Data). Because you can have multiple connections with a connector (using different authentication profiles), a name and description helps you identify the connection later.
  6. Upload the key file that you downloaded in the previous section.
  7. Click Test and Save Connection.

You can now set up an integration using the connection.

All data warehouse connectors support SSL encryption. By default, Totango uses SSL encryption during connecting. If the data warehouse server does not support SSL encryption, the connection will use an unencrypted connection to stream data from the data warehouse.



Question: How does Totango connect to the Google BigQuery database?

Answer: Totango connector uses Google BigQuery API.

Question: Does the Google BigQuery connector supports a read-only connection mode?

Answer: Yes. Totango Customer Data Hub is using a read-only mode on the connector level (we do not allow any queries with delete, insert, update, etc.). This is part of the service account user roles described above.

Question: Does Totango's Google BigQuery connector support shared tables?

Answer: Yes. you have access according to configured permissions.

Question: Does GoogleBigQuery connector support Cloud SQL federated tables or logical views?

Answer: Yes, it supports federated queries. Read more here.

Question: Does GoogleBigQuery connector support querying nested objects or array objects?

Answer: Yes, by using SQL JOIN as part of the query.

Question: Does GoogleBigQuery connector support querying partitioned tables?

Answer: Yes, it supports partitioned tables. Read more here.

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request