100 Snowflake Cost Optimization Techniques

My new 14 hours mega-course “100 Snowflake Cost Optimization Techniques” is live on Udemy! Check here my current best price on all video courses and practice tests.

All the tips are listed below. I’ll discuss them all in detail in my new course, with hands-on demos and experiments, ending-up with high-quality presentations and reviews. Check my promo clip — and other free videos — at the end.

No other current course, book or documentation around will offer as much insights and knowledge transfer on optimizing the costs on Snowflake accounts!

1. Virtual Warehouses

• Tip #1: Larger Virtual Warehouses May Actually Cost You Less
• Tip #2: Auto-Suspend Any Warehouse After One Minute
• Tip #3: Any Resumed Warehouse Will Cost You at Least One Minute
• Tip #4: Never Auto-Suspend Any Warehouse After Less Than One Minute
• Tip #5: X-Small Warehouses Could Be Powerful Enough
• Tip #6: Resized Warehouses are for More Complex Queries
• Tip #7: Multi-Cluster Warehouses are for Multiple Users and Concurrency
• Tip #8: Multi-Cluster Warehouses Should Always Have Min Clusters 1
• Tip #9: Use Economy Scaling Policy…