Hello, how do you optimize your data warehouse costs? @Madison Mae wrote a great article featuring 6 ways to reduce Snowflake costs: 1. Change your warehouse size 2. Decrease the number of warehouses running at the same time 3. Decrease the sync frequency of your data ingestion tool 4. Decrease the warehouse’s auto-resume period 5. Use materialized views 6. Change your Snowflake account plan I am curious to know which optimization has brought the most savings to you?

Reduce the number of materialized views needed.

Interesting! Why reduce thd number of materialized views?

Because you are looking at optimizing costs. Every time you execute a materialized view, it retrieves new data which means you are using compute costs. This is why materialized views are different from logical views.

This was a great article btw (as someone who writes cost optimization articles a lot).