connector

BigQuery

Google Cloud's serverless data warehouse.

Connection fields

Field	Required	Description
`project_id`	Yes	GCP project ID to run queries against.
`service_account_json`	Yes	Full contents of a service-account JSON key file (not a file path) — needs client_email and private_key.
`location`	No	BigQuery location, e.g. US or EU. Required for jobs in a single-region location outside the US/EU multi-regions.
`dataset`	No	Limits schema browsing to one dataset. If unset, every dataset in the project is enumerated, which can be slow on large projects.

Auth is a service-account JSON key exchanged for an OAuth2 token via a signed JWT bearer assertion — the same service account must have BigQuery read/job-run permissions on the project.

Example configuration

{
  "project_id": "my-gcp-project",
  "service_account_json": "{\"type\": \"service_account\", \"client_email\": \"...\", \"private_key\": \"...\", ...}",
  "location": "US",
  "dataset": "analytics"
}

Caveats

service_account_json is the raw key file's JSON contents pasted in, not a path on disk — arcodash never reads a local file for this.