Snowflake Cost Optimization Advisor
Analyze and optimize Snowflake data warehouse costs through warehouse right-sizing, query performance tuning, storage efficiency, and organizational governance using resource monitors and FinOps practices.
SupaScore
83.6Best for
- ▸Reduce Snowflake monthly bills by 20-50% through warehouse right-sizing and auto-suspend optimization
- ▸Analyze ACCOUNT_USAGE views to identify cost drivers and establish warehouse-level attribution
- ▸Optimize multi-cluster warehouse scaling policies and eliminate oversized XL warehouses
- ▸Implement clustering keys and query optimization to reduce compute credits consumed
- ▸Set up resource monitors and credit alerts to prevent runaway warehouse costs
What you'll get
- ●Detailed warehouse utilization analysis with specific resize recommendations (e.g., 'ANALYTICS_WH: downsize from XL to L, projected 40% credit reduction')
- ●SQL queries to monitor ongoing costs with custom dashboards showing credit burn rate by warehouse and user
- ●Implementation roadmap with quick wins (auto-suspend tuning) and longer-term optimizations (clustering keys) with ROI estimates
Not designed for ↓
- ×General cloud cost optimization for AWS/Azure/GCP services outside Snowflake
- ×Snowflake data modeling or schema design decisions
- ×Migration strategies from other data warehouses to Snowflake
- ×Snowflake security configurations or access control setup
Current Snowflake account with ACCOUNT_USAGE schema access, recent credit consumption patterns, and existing warehouse configurations that need cost analysis.
Specific cost reduction recommendations with projected credit savings, SQL queries for monitoring, and warehouse configuration changes with implementation priority.
Evidence Policy
Enabled: this skill cites sources and distinguishes evidence from opinion.
Research Foundation: 7 sources (4 official docs, 1 industry frameworks, 1 books, 1 community practice)
This skill was developed through independent research and synthesis. SupaSkills is not affiliated with or endorsed by any cited author or organisation.
Version History
Initial release
Works well with
Need more depth?
Specialist skills that go deeper in areas this skill touches.
Common Workflows
Enterprise Data Platform Cost Optimization
Comprehensive cost reduction across entire data platform including Snowflake optimization, architecture review, and multi-cloud cost management.
Activate this skill in Claude Code
Sign up for free to access the full system prompt via REST API or MCP.
Start Free to Activate This Skill© 2026 Kill The Dragon GmbH. This skill and its system prompt are protected by copyright. Unauthorised redistribution is prohibited. Terms of Service · Legal Notice