Google BigQuery

:::info Required extra This connection requires the bigquery extra. See Installation. :::

Test data in Google BigQuery. Authentication uses a Service Account Key or Application Default Credentials (ADC) — including Workload Identity Federation (WIF), the GCE metadata server, and gcloud auth application-default login. The service account should have the BigQuery Job User and BigQuery Data Viewer roles.

When DATACONTRACT_BIGQUERY_ACCOUNT_INFO_JSON_PATH is not set, the CLI falls back to ADC automatically.

Server

servers:
  - server: production
    type: bigquery
    project: datameshexample-product
    dataset: datacontract_cli_test_dataset

Environment variables

Variable	Example	Description
`DATACONTRACT_BIGQUERY_ACCOUNT_INFO_JSON_PATH`	`~/service-access-key.json`	Service Account key JSON file. If unset, ADC/WIF is used.
`DATACONTRACT_BIGQUERY_IMPERSONATION_ACCOUNT`	`sa@project.iam.gserviceaccount.com`	Optional. Service account to impersonate (works with key file or ADC).
`DATACONTRACT_BIGQUERY_BILLING_PROJECT`	`my-compute-project`	Optional. Project to bill query jobs to. Requires `bigquery.jobUser` on the billing project and `bigquery.dataViewer` on the data project.

Server​

Environment variables​

Server

Environment variables