SHOW WAREHOUSES

Introduced or updated: v1.2.687

Returns a list of all existing warehouses along with their type and status.

Syntax

SHOW WAREHOUSES

Examples

SHOW WAREHOUSES;

┌───────────────────────────────────────────┐
│    warehouse   │      type      │  status │
├────────────────┼────────────────┼─────────┤
│ test_warehouse │ System-Managed │ Running │
└───────────────────────────────────────────┘