Skip to main content

RESUME WAREHOUSE

Introduced or updated: v1.2.687

Restarts a previously suspended warehouse, bringing it back online and re-allocating its machine resources. If there are no available nodes, the RESUME WAREHOUSE command will fail. When trying to resume a warehouse, ensure that the necessary resources are available for the warehouse to restart successfully.

Syntax

RESUME WAREHOUSE <warehouse_name>

Examples

This example resumes the test_warehouse warehouse:

RESUME WAREHOUSE test_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