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 analyze 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.
I think the reason why 90% of those accounts didn’t have resource monitors or regular optimizations in place was initially Snowflake is incredibly cost effective and typically had massive savings savings especially from on-prem migrations that we have done.
Companies though 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 9 Snowflake Cost and Risk Optimizations below. Enjoy!
Here we go: 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 past history and Warehouses 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.
You can join us to learn more about Cost Optimization at our webinar here!
See cost optimization automation code at the bottom of this post.
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 the workloads can automate additional cost savings with this automation for you.
See cost optimization automation code at the bottom of this post that helps you optimize auto_suspend.
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.
See cost optimization automation code at the bottom of this post.
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 you over paying for Storage. Too often we find costly setting related to Time Travel and/or Snowflake Stages.
See cost optimization automation code at the bottom of this post that helps you optimize Storage Costs.
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 warehosuses, 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:
Snowflake Data Cloud Cost Optimization and Snowflake
Data Cloud RISK Cost Reduction is really 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.
