The BigQuery authentication configuration establishes the connection between Treasure AI and your BigQuery project.
- In the Treasure AI console, navigate to Integration Hub > Authentications.
- Search for Google BigQuery and select it.
- Click New Authentication and fill in the connection details:
| Parameter | Description | Example |
|---|---|---|
| Name | A descriptive name for this connection | bigquery-cas-connection |
| JSON Keyfile | Paste the full contents of the JSON key file from GCP Step 3 | { "type": "service_account", ... } |
Note
Only JSON keyfile authentication is supported. OAuth user credentials are not supported for CDW connections used in CAS.
- Click Continue and complete the setup.
- Save the configuration.
After saving, the authentication is assigned a connectionId. You can find it in the URL of the authentication detail page (e.g., console.<region>.treasuredata.com/app/integrations/authentications/bigquery/123456 — the connectionId is 123456). You will need this ID in the next step.
You can also retrieve it via the CLI:
tdx connection show "bigquery-cas-connection"
# Look for the "id" field in the output