What happens when a virtual warehouse is resized?

Question

jateen chibabhai · Accepted Answer

When increasing the size of an active warehouse the compute resource for all running and queued queries on the warehouse are affected

jateen chibabhai · Answer

When reducing the size of a warehouse the compute resources are removed only when they are no longer being used to execute any current statements.

jateen chibabhai · Answer

The warehouse will be suspended while the new compute resource is provisioned and will resume automatically once provisioning is complete.

jateen chibabhai · Answer

Users who are trying to use the warehouse will receive an error message until the resizing is complete

List of questions