> ## Documentation Index
> Fetch the complete documentation index at: https://docs.abundly.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# BigQuery

> Ask questions about your data in plain English and get answers from Google BigQuery

Your agent can explore your BigQuery datasets and run SQL queries on your behalf — so you can get revenue breakdowns, spot trends, or run scheduled reports without writing a line of SQL. Point it at your data and ask in natural language; the agent discovers schemas, runs read-only queries, and returns results (with bytes processed so you can keep an eye on cost).

<Frame>
  <img src="https://mintcdn.com/abundly/pyzpBCDLw_OMJ4CX/images/bigquery-capability.png?fit=max&auto=format&n=pyzpBCDLw_OMJ4CX&q=85&s=d66b7134853ea7250f5b298c49a185f1" alt="Screenshot: BigQuery capability card in Settings → Capabilities with service account JSON configured" style={{ width: '400px', height: 'auto' }} width="878" height="942" data-path="images/bigquery-capability.png" />
</Frame>

## How to enable

Go to **Settings → Capabilities** and enable **BigQuery**. Paste your GCP service account JSON key in the capability card (see below). Credentials are stored as team secrets.

## Example use cases

* **Revenue and performance** — "Query our sales dataset in BigQuery and summarize revenue by region for last quarter"
* **Scheduled reports** — "Every Monday at 9am, run a query for last week's top 10 products and email the results to the team"
* **Data quality** — "Check the BigQuery table for duplicate order IDs and report any issues"
* **Exploration** — "List the tables in our analytics dataset and describe the schema of the events table so I know what we can analyze"
* **Cross-tool workflows** — "Pull last month's conversion numbers from BigQuery and add a summary to the weekly update in Notion"

<Frame>
  <img src="https://mintcdn.com/abundly/pyzpBCDLw_OMJ4CX/images/bigquery-chat-results.png?fit=max&auto=format&n=pyzpBCDLw_OMJ4CX&q=85&s=82ff8c5452a25ef5716889e7eec662ab" alt="Dr Plotts answering a question using BigQuery data" style={{ width: '400px', height: 'auto' }} width="1024" height="632" data-path="images/bigquery-chat-results.png" />
</Frame>

<Frame>
  <img src="https://mintcdn.com/abundly/pyzpBCDLw_OMJ4CX/images/bigquery-chart.png?fit=max&auto=format&n=pyzpBCDLw_OMJ4CX&q=85&s=3671badb6573696fbad040bdc0e0dab0" alt="Dr Plotts chart from BigQuery data" style={{ width: '400px', height: 'auto' }} width="1024" height="828" data-path="images/bigquery-chart.png" />
</Frame>

<Note>
  The agent runs read-only SELECT queries only (30-second timeout, 1 GB billing limit per query). Write operations and DDL are not supported. Always include a LIMIT clause to keep result sets manageable.
</Note>

## How to connect BigQuery

<Steps>
  <Step title="Create a GCP service account">
    In [Google Cloud Console](https://console.cloud.google.com/), create a service account and grant it:

    * **BigQuery Metadata Viewer** — explore datasets and tables
    * **BigQuery Data Viewer** — query data
    * **BigQuery Job User** — run queries
  </Step>

  <Step title="Create a JSON key">
    In IAM & Admin → Service Accounts, select the service account and choose **Create Key → JSON**. Download the key file.
  </Step>

  <Step title="Configure in Abundly">
    Go to **Settings → Capabilities** and enable **BigQuery**. Paste the entire contents of the JSON key file into the capability card. Credentials are stored in team secrets (secret type: GCP).
  </Step>
</Steps>

## Learn more

<CardGroup cols={2}>
  <Card title="Snowflake" icon="snowflake" href="/integrations/snowflake">
    Query and explore your Snowflake data warehouse from the agent.
  </Card>

  <Card title="Agent databases" icon="database" href="/features/agent-databases">
    Store and query structured data inside Abundly.
  </Card>
</CardGroup>