Our team received a massive bill for running Snowflake queries this month and my boss wants me to figure out how to optimize our SQL queries to bring those costs down immediately
Download run
Fan-out diagram
The searches the AI actually ran for this prompt.
SEED QUERY
Our team received a massive bill for running Snowflake queries this month and my boss wants me to figure out how to optimize our SQL queries to bring those costs down immediately
1 real search · 1 real-search pass
Snowflake documentation QUERY_HISTORY ACCOUNT_USAGE warehouse metering query optimization cost credits query profile auto suspend resource monitorsGoogle ↗
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 documentation QUERY_HISTORY ACCOUNT_USAGE warehouse metering query optimization cost credits query profile auto suspend resource monitors Google ↗
- Account Usage · docs.snowflake.com
- QUERY_METERING_HISTORY view · docs.snowflake.com
- Exploring execution times · docs.snowflake.com
- Cost Optimization · snowflake.com
- Getting Started with Cost and Performance Optimization · snowflake.com
- Cost Optimization · snowflake.com