Skip to main content

Warehouse

This page provides a comprehensive overview of Warehouse operations in Databend, organized by functionality for easy reference.

Warehouse Management

CommandDescription
CREATE WAREHOUSECreates a new warehouse for compute resources
ALTER WAREHOUSEModifies an existing warehouse configuration
DROP WAREHOUSERemoves a warehouse
RENAME WAREHOUSEChanges the name of a warehouse
SUSPEND WAREHOUSETemporarily stops a warehouse to save resources
RESUME WAREHOUSERestarts a suspended warehouse
USE WAREHOUSESets the current warehouse for the session

Warehouse Information

CommandDescription
SHOW WAREHOUSESLists all warehouses
SHOW ONLINE NODESDisplays 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.

Explore Databend Cloud for FREE
Low-cost
Fast Analytics
Easy Data Ingestion
Elastic Scaling
Try it today