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, from the menu in the upper left corner, click on the APIs and Services > Credentials menu.
    Screenshot 2025-05-06 at 9.49.18 AM.png
  2. Near the top of the screen, click on the + Create credentials button, then select Service account.
    Screenshot 2025-05-06 at 9.53.51 AM.png
    Service account users only have access to applications and APIs.
  3. In the Service account name field, enter a name for the service account such as "Totango Integration". The Service account ID field will automatically populate, leave it alone, then click on the Create and continue button.
    Screenshot 2025-05-06 at 9.59.57 AM.png
  4. In the Grant this service account access to project section, click on Select a role. In the Filter box that appears type "Viewer", then select Viewer from the list that appears (gives read access to resources that enable Totango connector to test the connection).
    Screenshot 2025-05-06 at 10.01.28 AM.png
  5. Click on the + Add another role button, click on Select a role. In the Filter box that appears type "BigQuery Data Viewer", then select BigQuery Data Viewer from the list that appears (gives view access to  datasets). 
    Screenshot 2025-05-06 at 10.10.27 AM.pngScreenshot 2025-05-06 at 10.12.45 AM.png
  6. Click Done.

2. Download a Google BigQuery key file

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

  1. From the list of Service accounts, select the service account that you just created, then under the Actions column on the far right, click on the pencil icon to Edit service account:
    Screenshot 2025-05-06 at 10.16.52 AM.png
  2. Click on Keys, then Add Key > Create New Key.
    Screenshot 2025-05-06 at 10.18.44 AM.png
  3. Choose Json, and click on Create
    Screenshot 2025-05-06 at 10.20.11 AM.png

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).
    mceclip0.png
  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.

 

FAQs

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