Performance - satyamsingh1004/snowflake GitHub Wiki

Scaling In and Out: If multi-cluster/elastic warehousing is available (Enterprise edition or above) a warehouse is capable of scaling out in times of increased demand. (Adding temporary teams, made up of a collection of temporary workers). If multi-cluster scaling out takes place, clusters are added for the period of demand and then clusters are removed (snap back) when demand decreases. (Removing temporary teams). The number of servers in the original cluster dictates the number of servers in each cluster during periods where the warehouse scales out by adding clusters.

Snowflake recommends always starting with eXtra-Small warehouses and only scaling up if you find a compelling reason do that. XS warehouses cost less than five dollars to run for an hour. Our biggest warehouse, the 6XL, costs over 500 times that amount, because it's like
running 512 XS warehouses at one time.

These cost administrators will also be able to calculate whether a change in warehouse size will result in enough time savings to justify the costs
incurred or even balance them out.