Connect Google BigQuery

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

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

Before you start

• Google Cloud project with BigQuery API enabled

• An existing BigQuery dataset

Step 1 — Create a service account with BigQuery roles

1. GCP → IAM & Admin → Service Accounts → Create

2. Assign roles: BigQuery Data Viewer + BigQuery Job User

3. 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.

1. In the target project → IAM & Admin → IAM → Grant Access

2. Add the service account email and assign both roles

What to enter in HARVEN

• Dataset ID — BigQuery dataset short name (GCP → BigQuery → dataset name, without project)

• Project ID — GCP project ID if the dataset is in a different project than the service account (GCP → Dashboard → Project ID, optional)

• Service Account Key — JSON key content (GCP → Service Accounts → Keys → JSON)

What HARVEN reads

• All tables from the BigQuery dataset are imported automatically (columns discovered automatically).

Official documentation

• BigQuery Service Accounts

Need help? Contact [email protected].