Was this helpful?
Scale a Warehouse
To schedule the scaling of a warehouse, see Schedule a Warehouse.
After creating a warehouse, you can scale the number of AUs up or down to resize the warehouse.
Note:  You can scale up to any allowable amount, but you can only scale down to the initial allotment of AUs. For example, if your installation was initially alloted 2AUs, you can scale up to 4 AUs, but you cannot scale down below 2 AUs.
Scaling up can improve query performance, enables the warehouse to handle increasing workloads (more users, more data), and improves data loading. Scaling up, however, does not require existing data to be reloaded or reorganized to get performance from the additional compute to the warehouse.
Dynamic scaling enables warehouses to scale up or down in size without a restart. This enables you to adjust resources available to a warehouse without interrupting workloads. This feature is only available in a 620.x or above warehouse. Any existing 610.x-based warehouses need to upgrade to enable this new feature.
Dynamic scaling features include:
Dynamic scaling takes less time to complete then an off-line scaling
In progress queries and transactions must complete before the dynamic scaling operation starts
New queries cannot start until the scaling completes
After scaling completes, existing sessions reconnect
Note: Upgrading your warehouse to enable dynamic scaling requires a support ticket. New warehouses use 620.x warehouses by default.
A warehouse must be running to scale it.
Note:  If you are running a 610.x-based warehouse, any scaling, up or down, takes the warehouse off-line and restarts the warehouse. During an off-line scaling, the warehouse/database will be unavailable and any active users’ work will be affected. If you are doing an off-line scaling, we recommend scaling during off hours.
To scale an Avalanche warehouse
1. On the Avalanche Warehouses page, click the name of the warehouse you want to scale. It must be in the Running state (see Restart a Warehouse or Restart a Database).
The Warehouse Details page is displayed.
2. On the Compute row, click Scale.
The Compute dialog opens.
3. Click the number of AUs you want to scale to.
4. Click Save and confirm the scaling.
The warehouse enters the Scaling state, and the Compute field reflects the new number of AUs.
After scaling is completed, the warehouse enters the Running state.
Last modified date: 05/15/2024