Categories:
Warehouse & Resource Monitor DDL

USE WAREHOUSE

Specifies the active/current warehouse for the session. A warehouse must be specified for a session and the warehouse must be running before queries and other DML statements can be executed 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>

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.