Skip to content

BigQuery

When adding a BigQuery connection in Tracelake, you’ll need to provide the following information:

Parameter Type Required Description Example
Project ID String Yes Google Cloud project ID my-project-123
Dataset String Yes BigQuery dataset name mydataset
Service Account Key File String No Path to Google Cloud service account JSON key file (alternative to default credentials) /path/to/key.json
Impersonate Service Account String No Service account email to impersonate sa@project.iam.gserviceaccount.com
Custom Credentials String No Custom Google OAuth2 credentials -

BigQuery supports multiple authentication methods:

If you’re running Tracelake on Google Cloud infrastructure or have gcloud configured locally, you can use default credentials by leaving the authentication fields empty.

Provide the path to a JSON key file for a service account with appropriate BigQuery permissions.

Use your current credentials to impersonate another service account. Provide the service account email address.