Want to scale load to an overflow warehouse based on load spikes but lack access to Snowflake Enterprise? Use Sundeck to automatically route work to a second warehouse when demand suggests.
Use a small warehouse as the default warehouse for most workloads. Then adaptively route heavy queries to a larger warehouse.
When queries complete during idle times, shutdown the Snowflake warehouse immediately. Avoid waiting until the next minute.
It might make sense to have several warehouses divided out by team during the workday but probably not at other times. On evenings and weekends, collapse to a single warehouse to avoid waste.
In a few quick steps, you can start using Sundeck to enhance your Snowflake environment.
Get more productive today!
