Use BigQuery safely with AI
Gives an AI assistant the habits to query BigQuery well: confirm the project, discover datasets and tables before writing SQL, keep scans and results small, and ask before any change to your data.
Use it when
- You want an assistant to answer questions from BigQuery without scanning the whole warehouse by accident
- You are not sure which project, dataset or table holds the data you need
- A query failed with a permission or not-found error and you want a clear cause
Tools it uses
list_dataset_idsget_dataset_infolist_table_idsget_table_infoexecute_sql
Which BigQuery table has our monthly order totals? Check the project first and keep the query small.
I'm using the project analytics-prod, which I've confirmed with you. I found a sales dataset in the EU location with an orders table partitioned by order_date. I queried the last 3 months of order_date, selecting only order_month and total_amount, and aggregated by month. The result is 3 rows, one per month. These figures cover only that date window.