# Connect BigQuery

Connect Google BigQuery so a Metric goal tracks a number from your warehouse, written as a SQL query by Brev.

Connect Google BigQuery so a KPI follows your warehouse. You describe the number, and Brev writes and checks the SQL.

## What you get from BigQuery {#what-you-get}

- A Metric goal that runs one saved query on every refresh.
- The SQL in plain view on the goal's connection.

## Connect BigQuery {#connect}

1. In Settings, click **Connections**, then type Google BigQuery in **Search connections**.
2. On its row, click **Connect**. The row may say Operator access: auto-track uses that same connection.
3. Sign in with Google and approve access.

> **Tip: Success check**
>
> The Google BigQuery row shows a **Connected** badge.

## Track a BigQuery number {#track}

1. Open a Metric goal and click **Auto-track**. Under **Ready to track**, pick Google BigQuery.
2. In **Describe a value in Google BigQuery**, say what to measure, such as "weekly active users".
3. Answer Brev's questions, such as which table or project to use. The project you name pays for each refresh.
4. Check the preview and today's value, then click **Connect**.

![The Auto-track menu open on a goal: apps under Connect to track, with Request access beside the ones Brev can't track yet.](https://help.brev.io/doc-assets/screenshots/auto-track-a-goal-open-auto-track.png)

> **Tip: Success check**
>
> The goal shows the BigQuery icon on its connection. Click its gear to read the SQL.

## After you connect BigQuery {#what-happens-next}

Brev reads the value at the frequency you picked. At Every 30 minutes, it reads every 30 minutes from 7 AM to 7 PM on weekdays (Sydney, New York or San Francisco time). Otherwise, it reads every 4 hours.

- To read it now, click the refresh icon on the goal's connection. An unchanged value adds no check-in.
- To see what it reads, hover over the connection or click its gear. The gear also changes the frequency.
- You can still add your own check-ins, for example to explain a change.

- A query that would read more than 10 GB on one refresh is refused. Filter on a date or partition column.
- An older Brev BigQuery connection keeps refreshing the goals it already tracks.

---

Use Brev from Claude, ChatGPT or Cursor with the Brev MCP server, https://mcp.brev.io/mcp: [set it up](https://help.brev.io/connect-ai-assistant/).