Snowflake Cost Optimizer

Cut Snowflake spend by analyzing warehouse and query costs. Surfaces the most expensive queries, detects anti-patterns like full scans and oversized warehouses, and recommends concrete optimizations.

This skill audits Snowflake cost and performance. It analyzes warehouse query costs, ranks the most expensive queries, detects anti-patterns such as full table scans, missing clustering, idle warehouses, and oversized compute, and recommends concrete fixes — right-sizing warehouses, adding clustering keys, and rewriting queries to reduce credits burned.

When to use

Use when investigating Snowflake costs, finding the most expensive queries, detecting query and warehouse anti-patterns, or right-sizing compute to cut spend.

Examples

Find costly queries

Rank spend by query

Analyze my Snowflake account and show the ten most expensive queries this month with why they cost so much

Right-size warehouses

Reduce compute spend

Review my Snowflake warehouse usage and recommend which warehouses to downsize or auto-suspend to cut credits

Fix an anti-pattern

Optimize a scan

This Snowflake query does a full table scan every run. Suggest clustering keys and a rewrite to reduce cost