BigQuery
Connect & Ingest data from / to a BigQuery database
The following credentials keys are accepted:
project
(required) -> The GCP project ID for the projectkey_file
(required) -> The Service Account JSONdataset
(required) -> The default dataset (like a schema)location
(optional) -> The location of the account, such asUS
orEU
. Default isUS
.
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>
export BIGQUERY='{type: bigquery, project: my-google-project, dataset: public, location: US, key_file: /path/to/service.account.json}'
Last modified 1mo ago