DROP WAREHOUSE

Removes the specified virtual warehouse from the system.

See also:

ALTER WAREHOUSE , CREATE WAREHOUSE , DESCRIBE WAREHOUSE , SHOW WAREHOUSES

Syntax

DROP WAREHOUSE [ IF EXISTS ] <name>
Copy

Parameters

name

Specifies the identifier for the warehouse to drop. If the identifier contains spaces, special characters, or mixed-case characters, the entire string must be enclosed in double quotes. Identifiers enclosed in double quotes are also case-sensitive.

Usage notes

  • Dropped warehouses cannot be recovered; they must be recreated.

  • When this command is issued, Snowflake aborts any queries being processed by the specified warehouse and shuts down the compute resources utilized by the warehouse. Metering on the compute resources for the warehouse stops after all running statements complete.

Tip

To prevent in-progress queries from being aborted for a dropped warehouse (i.e. you wish the queries to be completed):

  1. First suspend the warehouse.

  2. After all the queries have completed, drop the warehouse.