ALTER WAREHOUSE UNASSIGN NODES

Removes assigned nodes from one or more clusters in a warehouse.

note

This command requires system management support and an enterprise license.

Syntax

ALTER WAREHOUSE <warehouse_name> UNASSIGN NODES
(
    UNASSIGN <node_count> NODES [ FROM '<node_group>' ] FOR <cluster_name>
    [ , UNASSIGN <node_count> NODES [ FROM '<node_group>' ] FOR <cluster_name> , ... ]
)

Parameters

Parameter	Description
<warehouse_name>	The target warehouse.
<node_count>	Number of nodes to remove.
FROM '<node_group>'	Optional node group selector.
<cluster_name>	The target cluster inside the warehouse.

Example

ALTER WAREHOUSE etl_wh UNASSIGN NODES
(
    UNASSIGN 1 NODES FOR c1,
    UNASSIGN 1 NODES FROM 'default' FOR c2
);