Find expensive queries and recommend practical warehouse cost reductions.
#cost
#performance
#warehouse
#finops
Analyze and reduce warehouse spend for this workload.
Platform: [Snowflake / BigQuery / Redshift / Databricks]
Monthly spend concern: [amount or % growth]
Top expensive queries or jobs:
[Paste query IDs, SQL, or descriptions]
Current practices: [clustering / partitioning / materializations]
Provide:
1. Cost drivers you can infer
2. Query rewrites or modeling changes
3. Materialization / clustering / partition advice
4. Scheduling and warehouse-sizing tips
5. Quick wins vs longer-term refactors
6. Metrics to track after changes
Prompts are starting points. Review outputs before using them in production.
Warehouse Cost Optimizer
GPT-4