Our Snowflake bill is through the roof because of poorly optimized dbt models. What are the most effective techniques to push down filtering and avoid full table scans?
Download run
Fan-out diagram
The searches the AI actually ran for this prompt.
SEED QUERY
Our Snowflake bill is through the roof because of poorly optimized dbt models. What are the most effective techniques to push down filtering and avoid full table scans?
1 real search · 1 real-search pass
Snowflake micro-partition pruning query profile clustering keys official documentation dbt incremental models predicate pushdownGoogle ↗
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 1 queries…
Searches and sources
ChatGPT1 real searches · gpt-6
Snowflake micro-partition pruning query profile clustering keys official documentation dbt incremental models predicate pushdown Google ↗
- Performance · snowflake.com
- Micro-partitions & Data Clustering · docs.snowflake.com
- Cost Optimization · snowflake.com