I have been working with Snowflake since the beginning of 2018 and it has been one of the most fun and scaleable data solutions I have worked with in my 27++ year data engineer, data architect, entrepreneur, and data thought leader career. With great power (almost unlimited scale – only limited by Snowflakes’ allocation of Compute within an Availability Zone) also comes great responsibility.
Over the last 3 years, I have analyzed over 100 Snowflake accounts and about 90% of them were not fully optimized for Cloud data costs. This is why my team and I are so excited to have created Snoptimizer (the first AUTOMATED Snowflake Cost Optimization Service). Easily optimize your Snowflake Data Cloud Account here in a few hours.
One reason why 90% of those accounts lacked resource monitors or regular optimizations is that Snowflake is initially very cost-effective and typically provides significant savings, particularly for on-prem migrations we have completed. However, companies that do not optimize their Data Cloud Costs are missing out big time! This is why we designed Snoptimizer and I’m also SHARING my top 6 Snowflake Cost and Risk Optimizations below.
Enjoy!
My Snowflake Cost Optimization and Cost Risk Reduction Best Practices
Best Practice #1 – Resource Monitors.
One of the first things that Snoptimizer does is automate daily Resource Monitors at a warehouse level based on all the Snowflake Metadata database history and warehouse and Resource Monitor settings. This gets set almost immediately after you purchase Snoptimizer. BOOM. This has both huge cost risk reduction limits and guardrails for all of your warehouse compute.
Â
Best Practice #2 – Auto Suspend Setting Optimization.
Another optimization automated by Snoptimizer is looking at the Warehouse workloads and automating changes to the Auto Suspend settings. BOOM. Depending on workloads can automate additional cost savings with this automation for you.
Best Practice #3 – Monitoring Cloud Services Consumption Optimization
Snoptimizer immediately looks to see if you have any large costs associated with Cloud Services on your Snowflake Account.
Best Practice #4 – Regular Monitoring of Storage Usage Across your entire Snowflake Account.
Snoptimizer immediately reviews your Storage History over the past 60 days and looks at if you have any errant settings that have to overpay for Storage. Too often we find cossetting stings related to Time Travel and/or Snowflake Stages.
Best Practice #5 – Daily Monitoring of Warehouse Compute.
Besides just adding Resource Monitors that suspend Warehouses we also provide daily monitoring of Snowflake Warehouse consumption reporting daily spikes and anomalies or changes in rolling averages. Most accounts we come across do not have regular monitoring of warehouse usage on regular proactive settings.
Best Practice #6 – Regular Monitoring of New Snowflake Services.
Besides monitoring compute warehouses, Snoptimizer also immediately starts monitoring consumption on all the existing and new (private preview and after) Cloud Services that incur costs from Automatic Clustering to Search Optimization to Materialized Views and all existing and new costs. This is a huge benefit to the automation of Snoptimizer. We are ALWAYS looking out for your cost consumption optimization and cost risk reduction! We are always there for you!
Conclusion:
Data Cloud RISK Cost Reduction is so so important to do immediately on your Snowflake Account. What are you waiting for? Buy Snoptimizer now and be optimized in a few hours along with regular cost optimization monitoring. If a new warehouse appears, we have you covered!