SHEET 01Data & Analytics IntegrationBQ

BigQuery Integration

Integrate Google BigQuery for large-scale data analytics, querying, and pipeline orchestration.

Get a demo All integrations
  • Data & Analytics
  • < 5 min setup
  • Read + Write, Real-time
  • SOC 2
  • GDPR
BigQuerySOURCEDataSYNCAgentGOVERNEDActionsOUT
5Event triggers
5Agent actions
4Data types synced
< 5 minTime to connect
SHEET 02Triggers & ActionsI/O

What you can automate with BigQuery

Connect BigQuery events to AI agent workflows with pre-built triggers and actions.

IN → Triggers5 events
  • TRG-01

    Table Updated

    Fires when data is inserted or modified in a BigQuery table.

  • TRG-02

    Scheduled Query Completed

    Triggers when a scheduled query finishes.

  • TRG-03

    Job Failed

    Fires when a BigQuery job encounters an error.

  • TRG-04

    Dataset Created

    Triggers when a new dataset is created.

  • TRG-05

    Export Completed

    Fires when a table export job completes.

Actions → OUT5 actions
  • ACT-01

    Run Query

    Executes a SQL query on BigQuery and returns results.

  • ACT-02

    Insert Rows

    Streams rows into a BigQuery table.

  • ACT-03

    Create Table

    Creates a new table with a specified schema.

  • ACT-04

    Export Data

    Exports table data to Google Cloud Storage.

  • ACT-05

    Create Scheduled Query

    Sets up a recurring query in BigQuery.

SHEET 03Data SyncedREAD + WRITE

Data types available through this integration

BigQuery sync schemaRead + Write, Real-time
DS-01Tables & Datasets
DS-02Query Results
DS-03Job Metadata
DS-04Schemas
SHEET 04Use CasesFIELD

How enterprises use BigQuery with assistents

UC-01Live

Natural Language BI

Users ask business questions in plain language and agents translate them to BigQuery SQL.

UC-02Live

Anomaly Detection

Agents run continuous queries to detect data anomalies and alert stakeholders.

UC-03Live

Report Automation

Generate and distribute recurring business reports from BigQuery data.

SHEET 05Specification NotesFAQ

Questions about the BigQuery integration

How is BigQuery authentication handled?

The integration uses Google Cloud service accounts with IAM roles for fine-grained access control.

Can I limit which datasets agents can access?

Yes. Access is controlled through BigQuery IAM permissions at the dataset and table level.

Are query costs tracked?

Yes. The connector tracks bytes scanned and estimated costs per query for budget management.

SHEET 06Related IntegrationsLINKED

Explore more integrations

INT-01

Snowflake

Connect Snowflake data warehouse for querying, analytics, and real-time data pipeline integration.

Data & Analytics
INT-02

Databricks

Connect Databricks for lakehouse analytics, ML model serving, and data pipeline integration.

Data & Analytics
INT-03

Redshift

Integrate Amazon Redshift for data warehousing, analytics queries, and pipeline orchestration.

Data & Analytics
INT-04

PostgreSQL

Connect PostgreSQL databases for direct querying, data sync, and real-time change data capture.

Data & Analytics
SHEET 07ProductsPRD-01..03

Power your BigQuery integration with AI agents

PRD-01

Agent Builder

Create AI agents that connect to BigQuery with natural language — no code required.

Learn more
PRD-02

Workflow Builder

Build multi-step workflows that automate actions across BigQuery and other systems.

Learn more
PRD-03

Agent Governance

Enforce permissions, audit trails, and compliance on every agent action in BigQuery.

Learn more
SHEET 08Sign-offREADY

Ready to connect BigQuery?

Schedule a personalized demo to see how assistents’s AI agents integrate with BigQuery for your organization.

Get a demo Explore platform
Connector
BigQuery
Category
Data & Analytics
Sync
Read + Write, Real-time
Setup
< 5 min
Compliance
SOC 2 · GDPR