Google BigQuery

This page describes how to configure Google BigQuery as a Census destination.

🏃‍♀️ Getting Started
In this guide, we will show you how to connect Census to Google BigQuery as a destination.
If you are configuring Google BigQuery as a source (to query data from BigQuery to sync elsewhere), that process is documented separately here: Google BigQuery as a Source​
1.Visit the Destinations page and click + New Destination.
2.Enter your Google Cloud Project ID.
🔑  Permissions and Service Accounts
In order to connect to your BigQuery projects, Census uses a service account. This service account can be provided by you or managed by Census (recommended).
Option A: Upload Service Account Key
If you would prefer to have Census to use a service account that you own (instead of our automatically-managed account) to connect to BigQuery, you may provide its service account key JSON file here.
Option B: Use Census-managed Service Account
Otherwise, one you save your connection, Census will create a dedicated Google Cloud Service Account for each BigQuery destination. After the previous step, this account was created. To load data into BigQuery, the account needs the appropriate permissions.
Click the Activate Cloud Shell (near top right) icon in Google Cloud and execute the following commands.
Replace cs-sandbox-12345 with your Project ID.
Replace census-12345abcd1234[email protected] with the service account provided in the Census UI.
gcloud projects add-iam-policy-binding cs-sandbox-123456 \
  --member serviceAccount:census-12345abcd123451[email protected] \
  --role roles/bigquery.dataOwner
​
  gcloud projects add-iam-policy-binding cs-sandbox-123456 \
  --member serviceAccount:census-12345abcd123451[email protected] \
  --role roles/bigquery.jobUser
🗄️ Supported Objects and Behaviors
​
Object Name
Supported?
​Identifiers​
Behavior
Table
✅
Primary Keys or Columns with Uniqueness Constraints
Update or Create, Update Only, Append
​Contact us if you want Census to support more Sync behaviors for BigQuery.
🚦Network Access Controls
While BigQuery itself doesn't support IP allow lists, you can use VPC Service Controls to wrap your BigQuery instance and limit access. You can find Census's set of IP address for your region in Network Access Controls.
When using VPC Service Controls, you will also need to allow BigQuery unloads to the Census GCP bucket. To do that, you'll need to add gs://sutrolabs-giza-unloads-production in the allow list for BigQuery unloads.
🚑 Need help connecting to Google BigQuery?
You can send our support team an email at sup[email protected] or start a conversation from the in-app chat.

Destinations - Previous

Google Analytics 4

Next - Destinations

Google Cloud Storage

Last modified 1mo ago

Object Name	Supported?	Identifiers	Behavior
Table	✅	Primary Keys or Columns with Uniqueness Constraints	Update or Create, Update Only, Append