USE WAREHOUSE¶

Specifies the active/current virtual warehouse for the session. You must specify a warehouse for a session, and the warehouse must be running before you can execute queries and DML statements in the session.

To view the current warehouse for a session, call the CURRENT_WAREHOUSE context function.

See also:: ALTER WAREHOUSE , CREATE WAREHOUSE , SHOW WAREHOUSES

Syntax¶

USE WAREHOUSE <name>

Copy

Parameters¶

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

Examples¶

USE WAREHOUSE mywarehouse;

Copy