Connect Google BigQuery - HARVEN Help Center

HARVEN

Help Center

TAB

to ask AI

Imports tables from a BigQuery dataset. Columns are discovered automatically.

For the general flow of adding a source, see Connect Data Sources.

Prerequisites

Google Cloud project with BigQuery API enabled
An existing BigQuery dataset

Setup

Step 1 — Create a service account with BigQuery roles

GCP → IAM & Admin → Service Accounts → Create
Assign roles: BigQuery Data Viewer + BigQuery Job User
Keys → Add Key → JSON

Step 2 — Cross-project access (if Project ID differs)

If the dataset belongs to a different project than the service account, the service account must also have BigQuery Data Viewer + BigQuery Job User in that target project.

In the target project → IAM & Admin → IAM → Grant Access
Add the service account email and assign both roles

Fields to fill in HARVEN

Field	Where to find it
Dataset	GCP → BigQuery → dataset name (without project)
BigQuery Project ID (optional)	GCP → Dashboard → Project ID
Service Account Key	GCP → Service Accounts → Keys → JSON

Collected data

(dynamic) — All tables from the BigQuery dataset are imported automatically when you save. After a table is added to the dataset or its columns change, open the source in HARVEN and click More → Refresh tables

Official documentation

BigQuery Service Accounts

Need help? Contact [email protected].