Databases & CRM

Set up Google BigQuery

Connect a BigQuery dataset with a service-account key. Every table becomes a findable concept — columns, types, sample values, relationships — and tables with a declared primary key also become situated records with exact rollups. Read-only by scope and by construction.

In the Google Cloud console open IAM & Admin → Service accounts and create (or pick) a service account; grant it BigQuery Data Viewer and BigQuery Job User.
Open the account → Keys → Add key → Create new key → JSON, and download it.
Documents → Google BigQuery: enter the project ID and the dataset, and paste the WHOLE downloaded key file into the key field, braces included.
Choose access groups, Test, then Sync.

BigQuery's primary/foreign keys are declared, not enforced — and many analytics datasets declare none. Tables without a declared primary key still become concepts (“which table holds the refunds”), just not per-record surfaces; declare keys on the tables that are really registries to get records too.

Was this page helpful?

Was this page helpful? Sign in with Google Sign in to tell us — or leave a comment.

Last updated 29 Aug 2026