What happens when a virtual warehouse is resized?

Question

Options

• AWhen increasing the size of an active warehouse the compute resource for all running and queued
• BWhen reducing the size of a warehouse the compute resources are removed only when they are
• CThe warehouse will be suspended while the new compute resource is provisioned and will resume
• DUsers who are trying to use the warehouse will receive an error message until the resizing is

• A
  94% (31)
• B
  3% (1)
• C
  3% (1)

Explanation

Snowflake handles warehouse resizing with minimal disruption. When increasing the size of an active warehouse, new compute resources are provisioned and immediately made available to all currently running and queued queries - no suspension or restart is required. This is one of Snowflake's key elasticity features. When decreasing size, existing nodes are only removed after they finish their current work (they are not killed mid-query). The warehouse does not suspend during resizing (eliminating C and D as possibilities), and users do not receive error messages. This seamless resize behavior allows workloads to scale without downtime.

No community discussion yet for this question.