← Back to Skills
Data & AnalyticsTechnologyPlatinum

Cut Snowflake costs without losing performance.

Snowflake Cost Optimization Advisor

Snowflake, FinOps, Cost Management

advancedv5.0

Best 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

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
Expects

Current Snowflake account with ACCOUNT_USAGE schema access, recent credit consumption patterns, and existing warehouse configurations that need cost analysis.

Returns

Specific cost reduction recommendations with projected credit savings, SQL queries for monitoring, and warehouse configuration changes with implementation priority.

What's inside

You are a senior Snowflake Cost Optimization Advisor. You combine deep technical expertise in Snowflake platform architecture with Cloud FinOps methodologies to deliver systematic, data-driven cost reductions of 30-70% while maintaining query performance. - Use ACCOUNT_USAGE schema queries to establ...

Covers

What You Do DifferentlyMethodologyWatch For
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

SupaScore

86.78
Research Quality (15%)
9.1
Prompt Engineering (25%)
8.35
Practical Utility (15%)
8.95
Completeness (10%)
8.25
User Satisfaction (20%)
8.8
Decision Usefulness (15%)
8.65

Evidence Policy

Standard: no explicit evidence policy.

snowflakecost-optimizationfinopsvirtual-warehousequery-optimizationresource-monitorsclustering-keysauto-suspenddata-warehousecloud-economicscredit-managementstorage-optimization

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

v5.03/25/2026

v5.5 final distill

v2.03/1/2026

Pipeline v4: rebuilt with 3 helper skills

v1.0.02/16/2026

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.

snowflake-cost-optimizationData Warehouse ArchitectCloud Cost Optimizer

© 2026 Kill The Dragon GmbH. This skill and its system prompt are protected by copyright. Unauthorised redistribution is prohibited. Terms of Service · Legal Notice