Warehouse

Warehouse-related SQL commands for Databend Cloud.

General Rules

Warehouse naming: 3–63 characters, A-Z, a-z, 0-9, and - only.
Identifiers: Bare identifiers may omit quotes when they contain no spaces or special characters; otherwise enclose with single quotes.
Numeric parameters: Accept integers or NULL. Supplying NULL resets the value to default (e.g., AUTO_SUSPEND = NULL equals 0).
Boolean parameters: Only TRUE/FALSE are accepted.
WITH keyword: May appear before the entire option list or ahead of each option. Options are whitespace-separated.

Command	Description
CREATE WAREHOUSE	Creates a new warehouse
USE WAREHOUSE	Sets the current warehouse for the session
SHOW WAREHOUSES	Lists all warehouses with optional filtering
ALTER WAREHOUSE	Suspends, resumes, or modifies warehouse settings
DROP WAREHOUSE	Removes a warehouse
REPLACE WAREHOUSE	Recreates a warehouse with new configuration
QUERY_HISTORY	Inspects query logs for a warehouse

note

A warehouse represents compute resources used to run queries in Databend Cloud.