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}'
- On top, click New Connection.
- Find the BigQuery icon or search for "BigQuery". Click on it.
- You will see a form, where you'll need to input your Connection name and Project ID.
- You will also need to upload a service account JSON file.
- Click Test to verify connectivity.
- Click Save to save the connection.
If your database resource is secured behind a cloud firewall, please whitelist the IP addresses listed here depending on your region. We may not be able to establish a connection without this step.
Last modified 1mo ago