BigQuery

Connect BigQuery to query datasets and access analytics through Cendriix agents.

Overview

How to connect

1. Navigate to Settings → Integrations → Connectors
2. Click Connect on the BigQuery integration
3. Sign in with your Google account and authorize read-only access
4. Once authorized, BigQuery datasets become available to Cendriix agents

Admin setup (self-hosted)

If you’re running Cendriix on your own infrastructure, an admin needs to:

1. Create OAuth credentials in Google Cloud Console 
2. Enable the BigQuery API in your project
3. Set the redirect URL to: https://api.<your-domain>/v1/connectors/bigquery/oauth/callback
4. Store the credentials in AWS Secrets Manager at cendriix/prod/connectors/bigquery:

   { "client_id": "...", "client_secret": "..." }

Capabilities

Once connected, Cendriix agents can:

• Run read-only queries against BigQuery datasets
• Access table schemas and metadata
• Reference analytics data for reporting workflows

Security notes

• Google OAuth tokens support refresh with offline access
• Revocation available via Google’s OAuth revocation endpoint
• Read-only scope limits access to querying only
• Disconnect at any time from Settings → Integrations → Connectors

Further reading

• BigQuery API Overview 
• Google OAuth 2.0