Data Source

Google BigQuery

Run SQL queries against your BigQuery data warehouse via service account

Google BigQuery is a serverless, highly scalable cloud data warehouse. CipherSense Agents connects via a service account JSON key to run standard SQL queries against your datasets and pass results to Agent nodes as structured context.

Official documentation

Setup

Create a service account

In Google Cloud Console: IAM & Admin > Service Accounts > Create Service Account. Grant the BigQuery Data Viewer and BigQuery Job User roles.

Google Cloud Console

Download the service account JSON key

In the Service Account list: click your account > Keys > Add Key > Create new key > JSON. Download the JSON file — treat this as a secret.

Add the integration in CipherSense Agents

Go to Project > Integrations > Add Integration > Google BigQuery. Paste the contents of your service account JSON key. Click Save & Test.

Connection Fields

Fields required when adding this integration in your Project › Integrations.

Field	Required	Description
GCP Project ID	Required	Your Google Cloud project ID. Found in the Google Cloud Console home page.
Service Account Key (JSON)	Required	Full JSON contents of the service account key file downloaded from IAM & Admin > Service Accounts.
Dataset Location	Optional	Geographic location of your BigQuery datasets (e.g. US, EU, us-central1). Defaults to US.

Common Use Cases

Query petabyte-scale analytics tables for agent contextFetch aggregated business metrics for report generationRead ML training data for AI enrichment workflowsAnalyse user behaviour data for personalisation agents

Ready to connect Google BigQuery?

Add this integration from your project dashboard and wire it into a workflow.

Open Dashboard ← Back to Integrations