Warehouse
This page provides a comprehensive overview of Warehouse operations in Databend, organized by functionality for easy reference.
Warehouse Management
| Command | Description |
|---|---|
| CREATE WAREHOUSE | Creates a new warehouse for compute resources |
| ALTER WAREHOUSE | Modifies an existing warehouse configuration |
| DROP WAREHOUSE | Removes a warehouse |
| RENAME WAREHOUSE | Changes the name of a warehouse |
| SUSPEND WAREHOUSE | Temporarily stops a warehouse to save resources |
| RESUME WAREHOUSE | Restarts a suspended warehouse |
| USE WAREHOUSE | Sets the current warehouse for the session |
Warehouse Information
| Command | Description |
|---|---|
| SHOW WAREHOUSES | Lists all warehouses |
| SHOW ONLINE NODES | Displays active compute nodes in the current warehouse |
note
Warehouses in Databend represent compute resources that execute queries. They can be scaled up or down based on workload requirements and can be suspended when not in use to optimize costs.