Warehouse & resource monitor DDL¶

A virtual warehouse is a cluster of compute resources. A warehouse is needed to execute certain types of SQL statements because it provides resources such as CPU, memory, and local storage.

Resource monitors can be used to control credit usage for warehouses. A resource monitor specifies a monthly credit quota, one or more credit usage thresholds, and actions to perform when the thresholds are reached. Each resource monitor can be associated with one or more warehouses.

Virtual warehouses¶

CREATE WAREHOUSE
ALTER WAREHOUSE
DESCRIBE WAREHOUSE
DROP WAREHOUSE
USE WAREHOUSE
SHOW WAREHOUSES

Resource monitors¶

CREATE RESOURCE MONITOR
ALTER RESOURCE MONITOR
DROP RESOURCE MONITOR
SHOW RESOURCE MONITORS