Links

BigQuery

Connect & Ingest data from / to a BigQuery database

Sling CLI 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)
  • location (optional) -> The location of the account, such as US or EU. Default is US.
Here is an example of setting a connection named BIGQUERY. We must provide the type=bigquery property:
$ sling conns set BIGQUERY type=bigquery project=<project> dataset=<dataset> key_file=/path/to/service.account.json location=<location>

Environment Variable

export BIGQUERY='{type: bigquery, project: my-google-project, dataset: public, location: US, key_file: /path/to/service.account.json}'
If you are facing issues connecting, please reach out to us at [email protected].
Last modified 1mo ago