Auto-scale:
↑ max
If new_max_clusters > running_clusters, no changes until additional clusters are needed.
↓ max
If new_max_clusters < running_clusters, excess clusters shut down when they finish executing statements and the scaling policy conditions are met.
↑ min
If new_min_clusters > running_clusters, additional clusters immediately started to meet the minimum.
↓ min
If new_min_clusters < running_clusters, excess clusters shut down when they finish executing statements and the scaling policy conditions are met.
Based on the Snowflake documentation, additional clusters are started immediately if the MAX_CLUSTER_COUNT is increased and the new maximum number of clusters is greater than the number of running clusters. This ensures that the warehouse can handle the increased workload by scaling out to additional clusters as needed.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Gudref
Highly Voted 1 year, 2 months agobor4un
Most Recent 2 months, 4 weeks agoMultiCloudIronMan
3 months, 3 weeks agoMayankb024
8 months, 2 weeks agoDR369
1 year, 3 months ago