Integrations
BigQuery
How to get your BigQuery API key and connect it to Nova Admin.
Connect a GCP BigQuery project by entering its projectId (and optionally a defaultDataset). Authentication uses Application Default Credentials — grant the runtime service account BigQuery Data Viewer + BigQuery Job User on the project beforehand.
Prerequisites
- A BigQuery account. Sign up at https://console.cloud.google.com/iam-admin/serviceaccounts?project=nova-prod.
- An active Nova Admin workspace. Go to /agents/integrations to connect.
Steps
- Open the GCP console for the project hosting the BigQuery dataset.
- Grant the Cloud Functions runtime service account (e.g.
162939303532-compute@developer.gserviceaccount.com) theBigQuery Data ViewerandBigQuery Job Userroles. - Enter the projectId here (e.g.
nova-prod). - Optionally set a defaultDataset (e.g.
analytics_379350696) so actions can omit it.
Credential fields
| Field | Required | Description |
|---|---|---|
| GCP Project ID | Yes | string (e.g. e.g. nova-prod) |
| Default Dataset | No | string (e.g. e.g. analytics_379350696) |
Troubleshooting
- Invalid credentials: verify the key was copied in full with no trailing spaces.
- Key not working: check that your BigQuery account has API access enabled and billing is active if required.
- Need help?: refer to the BigQuery documentation.