Warehouse SQL Commands
This page lists warehouse-related SQL commands for self-hosted deployments with system-managed resources management enabled.
SHOW ONLINE NODES
Lists online query nodes in the tenant.
SHOW ONLINE NODES
SHOW ONLINE NODES;
CREATE WAREHOUSE
Creates a system-managed warehouse by specifying the number of nodes.
CREATE WAREHOUSE <warehouse_name>
WITH warehouse_size = <node_count>
CREATE WAREHOUSE wh1 WITH warehouse_size = 2;
ALTER WAREHOUSE
Manages clusters in a warehouse.
ALTER WAREHOUSE <warehouse_name>
ADD CLUSTER <cluster_name> WITH CLUSTER_SIZE = <node_count>
ALTER WAREHOUSE <warehouse_name>
RENAME CLUSTER <old_cluster_name> TO <new_cluster_name>
ALTER WAREHOUSE <warehouse_name>
DROP CLUSTER <cluster_name>
ALTER WAREHOUSE wh1 ADD CLUSTER c1 WITH CLUSTER_SIZE = 2;
RENAME WAREHOUSE
Renames a warehouse.
RENAME WAREHOUSE <current_name> TO <new_name>
RENAME WAREHOUSE wh1 TO wh1_new;
SUSPEND WAREHOUSE
Suspends a warehouse.
SUSPEND WAREHOUSE <warehouse_name>
SUSPEND WAREHOUSE wh1;
RESUME WAREHOUSE
Resumes a suspended warehouse.
RESUME WAREHOUSE <warehouse_name>
RESUME WAREHOUSE wh1;