How to auto resize Snowflake warehouses up/down?
08:15 02 Jul 2021

I know multi-cluster warehouses can have an autoscaling policy to scale out, but is there a way to automate resizing up or down? I have a set of queries that deal with varying sizes of data, which means I sometimes only need a S warehouse, but sometimes need a XL. I don't think Snowflake provides a built-in mechanism to do this, so looking for advice on how to automate this, maybe with a SP?

snowflake-cloud-data-platform