Skip to main content

Connect BigQueryBusiness plan

Updated Nov 4, 2026

On My Data → Add data → Connect a warehouse or database, choose BigQuery. In Live mode Cognizon queries a dataset in your own GCP project directly, on your billing — nothing is copied out of it. In Copy mode, Cognizon copies one table into your workspace and refreshes it once a day.

Before you start

  • Create a service account in your own GCP project.
  • For Live mode, grant it roles/bigquery.dataViewer on the dataset and roles/bigquery.jobUser on the project. For Copy mode the same two roles apply to the table's dataset and project.
  • Have the service account's JSON key file ready to paste in — the whole file, including the braces.
  • Connecting BigQuery — either mode — requires a plan with connectors enabled (Business or Enterprise).

Steps — Live (query in place)

  1. On My Data, open Add data → Connect a warehouse or database, then choose Live — query in place.
  2. Pick BigQuery.
  3. Fill in: Name, Project, Dataset, Location (optional — the BigQuery region or multi-region, if you know it), and Service account key (JSON).
  4. Click Test connection, then Save connection once it passes.
  5. Pick a Table from the list Cognizon discovered, give it a Dataset name, and register it. Optionally set a Bytes cap per query (optional) in TiB — BigQuery's maximumBytesBilled, a belt against a runaway query.

Steps — Copy (bring it into Cognizon)

  1. On My Data, open Add data → Connect a warehouse or database, then choose Copy — bring it into Cognizon.
  2. Set Source type to BigQuery.
  3. Fill in Name, Table (the fully-qualified project.dataset.table name), and Service account key (JSON).
  4. Click Test connection, then Connect source. Cognizon copies the table into your workspace and refreshes it once a day.

Good to know

  • Live queries run in your own project, on your own billing — Cognizon never copies rows out of it.
  • The service account key is stored in Google Secret Manager, never in Cognizon's own database, for either mode.
  • Google Analytics 4: turn on GA4's free BigQuery export in your GA4 property, then choose Google Analytics in the Live list and enter your GA4 property ID. Cognizon fills in the export's analytics_<property id> dataset and continues with the same BigQuery form — there's no separate API pull.
  • Both BigQuery modes require a plan with connectors enabled (Business or Enterprise).

FAQ

Whose GCP project does the query run in?

Your own. You grant a service account in your project the roles Cognizon needs, and queries run — and are billed — there, not on Cognizon's infrastructure.

What permissions does the service account need?

roles/bigquery.dataViewer on the dataset, and roles/bigquery.jobUser on the project, so it can both read the data and run query jobs.

What's the bytes cap for?

An optional per-query ceiling (BigQuery's maximumBytesBilled), in TiB, so a runaway or unexpectedly large query can't blow through your BigQuery budget unnoticed.

Can I connect my Google Analytics 4 data?

Yes — turn on GA4's free BigQuery export in your GA4 property, then choose Google Analytics in the Live list and enter your property ID. Cognizon reads the export's dataset through the BigQuery connection.

What's the difference between Live and Copy for BigQuery?

Live queries your dataset directly every time, on your billing, with nothing copied. Copy brings one table into your workspace and refreshes it once a day instead.