BigQuery
Ask about GA4 events, billing exports and app data in BigQuery.
Dot writes the BigQuery SQL for each question and shows it with the answer.
Ryan Ortiz9:41 AM
@Dot Which GA4 traffic sources brought the most first-time buyers last month?
1 reply
DotAPP9:42 AM
6 steps · 36s · Access Online
Organic search: 3,120 first purchases, converting at 2.8%.
Source: BigQuery’s ga4.events_*.
Chart
Today
Ryan Ortiz9:41 AM
Dot Which GA4 traffic sources brought the most first-time buyers last month?
Dot9:42 AM
6 steps · 36s · Access online
Organic search: 3,120 first purchases, converting at 2.8%.
Source: BigQuery’s ga4.events_*.
Priya Shah9:41 AM
@Dot Which projects drove this month’s jump in our cloud bill?
1 reply
DotAPP9:42 AM
9 steps · 56s · Access Online
Spend rose $18K to $142K. The data-pipeline project accounts for $12K of it.
Source: BigQuery’s billing_export.
Here is the data.
| Project | This month | Change |
|---|---|---|
| data-pipeline | $58K | +$12K |
| web-prod | $41K | +$4K |
| ml-training | $22K | +$2K |
Today
Priya Shah9:41 AM
Dot Which projects drove this month’s jump in our cloud bill?
Dot9:42 AM
9 steps · 56s · Access online
Spend rose $18K to $142K. The data-pipeline project accounts for $12K of it.
Source: BigQuery’s billing_export.
- data-pipeline: $58K this month, +$12K change
- web-prod: $41K this month, +$4K change
- ml-training: $22K this month, +$2K change
Daniel Weber9:41 AM
@Dot Which app version crashes most since Monday’s release?
1 reply
DotAPP9:42 AM
8 steps · 45s · Access Online
5.2 on Android, mostly in the new photo picker.
Source: BigQuery’s crashlytics.
Chart
Today
Daniel Weber9:41 AM
Dot Which app version crashes most since Monday’s release?
Dot9:42 AM
8 steps · 45s · Access online
5.2 on Android, mostly in the new photo picker.
Source: BigQuery’s crashlytics.
How GetDot works with BigQuery
How Dot connects and what it reads
A service account key, with an optional execution project that runs and pays for the queries. List the datasets to sync, or leave the list empty for all of them.
Dot reads table and column metadata and recent INFORMATION_SCHEMA.JOBS history, to learn which tables your team uses most.
Every job carries labels naming the Dot user, the chat and what triggered it (a question, a schedule, a dashboard), which show up in your billing export.
Permissions and row-level security
The service account needs read access to the chosen datasets and the right to run query jobs in the execution project. Dot queries BigQuery in place; nothing is copied.
With per-user BigQuery access, each person’s questions run as their own Google account through domain-wide delegation, so BigQuery’s IAM and row access policies decide what they see. If Google refuses someone, the question fails; Dot never falls back to the service account.
Without it, Dot’s row-level rules (Team plan) filter each query by the asker’s groups or attributes.
Dot and Conversational Analytics in BigQuery
As of October 2026, Google’s Conversational Analytics in BigQuery is generally available (since July 2026). It is built into BigQuery Studio, inherits BigQuery’s access controls, and publishes agents to Gemini Enterprise, Data Studio (formerly Looker Studio) or your own app through its API. Google’s announcement does not mention Slack or Teams.
Choose it when your people already live in BigQuery Studio and BigQuery holds every answer. Choose Dot when the questions turn up in Slack, Teams or email, when the definitions live in Looker, dbt or Power BI, or when some of the data never made it into BigQuery.
Questions
More in Databases & spreadsheets
Connect your data.
Start for Free
Redshift
Postgres
AWS Athena
Databricks SQL
Microsoft SQL
MotherDuck