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].

BigTable

Clickhouse

Last modified 1mo ago