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}'

Sling Cloud Setup

  • In Sling Cloud, click the Connections link on the left sidebar.
  • 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.

IP Address Whitelisting

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.
If you are facing issues connecting, please reach out to us at [email protected].
Last modified 1mo ago