Can you walk me through optimizing our dbt models so our BigQuery bill stops spiking every single morning?
Download run
Fan-out diagram
The searches the AI actually ran for this prompt.
SEED QUERY
Can you walk me through optimizing our dbt models so our BigQuery bill stops spiking every single morning?
3 real searches · 1 real-search pass
BigQuery INFORMATION_SCHEMA.JOBS_BY_PROJECT total_bytes_billed dbt query labels documentationGoogle ↗
OBSERVED
dbt BigQuery incremental models insert_overwrite merge partition_by docsGoogle ↗
OBSERVED
BigQuery query plan execution details partition pruning dry run maximum_bytes_billed docsGoogle ↗
OBSERVED
Badge and edge weight = share of passes that produced the query. Hover a query for its intent and routing format.
Query classes
Google's semantic query class for every sub-query: what kind of answer each search is after, simulated vs real.
Classifying 3 queries…
Searches and sources
ChatGPT3 real searches · gpt-6
BigQuery INFORMATION_SCHEMA.JOBS_BY_PROJECT total_bytes_billed dbt query labels documentation Google ↗
dbt BigQuery incremental models insert_overwrite merge partition_by docs Google ↗
BigQuery query plan execution details partition pruning dry run maximum_bytes_billed docs Google ↗
- JOBS view | BigQuery | Google Cloud Documentation · docs.cloud.google.com
- BigQuery configurations · docs.getdbt.com
- Configure incremental models · docs.getdbt.com
- BigQuery ingestion-time partitioning and partition copy with dbt · docs.getdbt.com
Queries
3 queries · click a column to sort
| Query / type | Search | Intent | Query class | Routing format | Cluster | Freq ↓ | Weight |
|---|---|---|---|---|---|---|---|
BigQuery INFORMATION_SCHEMA.JOBS_BY_PROJECT total_bytes_billed dbt query labels documentation OBSERVED | Google ↗ AI Mode ↗ | — | — | — | — | 1x of 1 | |
dbt BigQuery incremental models insert_overwrite merge partition_by docs OBSERVED | Google ↗ AI Mode ↗ | — | — | — | — | 1x of 1 | |
BigQuery query plan execution details partition pruning dry run maximum_bytes_billed docs OBSERVED | Google ↗ AI Mode ↗ | — | — | — | — | 1x of 1 |