BigQuery

Connect to a BigQuery database

Setup

The following credentials keys are accepted:

• project (required) -> The GCP project ID for the project

• key_file (required) -> The Service Account JSON

• dataset (required) -> The default dataset (like a schema)

Here is an example of setting a connection named BIGQUERY:

# YAML format
export BIGQUERY="{type: bigquery, project: <project>, dataset: <dataset>, key_file: /path/to/service.account.json}"