Connect BigQuery

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 #

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

Connect BigQuery #

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.

Track a BigQuery number #

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.

After you connect BigQuery #

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.