Skip to main content

USE WAREHOUSE

Introduced or updated: v1.2.687

Binds the current session to a specific warehouse. Subsequent queries in the session will use this warehouse for execution.

Syntax

USE WAREHOUSE <warehouse_name>
ParameterDescription
warehouse_nameThe name of the warehouse to use. The command validates that the warehouse exists and is accessible.

Examples

Set a warehouse as active for the current session:

USE WAREHOUSE my_warehouse;
Try Databend Cloud for FREE

Multimodal, object-storage-native warehouse for BI, vectors, search, and geo.

Snowflake-compatible SQL with automatic scaling.

Sign up and get $200 in credits.

Try it today