BigQuery
Connect BigQuery to sanda: what to prepare, the fields the connection form asks for, and how its data lands in your warehouse.
Connect BigQuery
- Open the catalogue. In the console, go to Data · Connections and press New connection.
- Choose BigQuery. It is listed under databases; you can also search for it by name.
- Fill in the form. Enter the fields below. Credentials go straight to sanda’s sync engine and are never stored in sanda’s database.
- Choose what to sync. Pick the streams you want, and a sync mode for each. See choose what to sync.
- Run the first sync. sanda tests the connection, then lands each stream as a table in your warehouse.
Configuration fields
What the connection form asks for. Required fields are marked; the rest are optional.
| Field | Type | Required | Description |
|---|---|---|---|
| Credentials JSON | string, secret | Yes | The contents of your Service Account Key JSON file. |
| Default Dataset ID | string | No | The dataset ID to search for tables and views. If you are only loading data from one dataset, setting this option could result in much faster schema discovery. |
| Project ID | string | Yes | The GCP project ID for the project containing the target BigQuery dataset. |
Related
Something unclear or out of date? Tell us, and we will fix the page.