Lists all zones in the catalog, optionally filtered by name pattern.
SHOW ZONES [LIKE '<pattern>']## Overview Returns a result set listing all zones registered in the control plane catalog. Zones are the top-level containers in the DeltaForge three-level namespace (zone.schema.table). This command provides a quick overview of the data lake's organizational structure. ## Behavior - Without the LIKE clause, all zones in the account are returned. - When LIKE is specified, the pattern is applied to zone names using SQL wildcard matching (% and _), case-insensitively. - The command is routed through the control plane catalog API. A valid catalog router connection is required. - The result set includes zone metadata such as zone name, type, storage root, comment, and audit timestamps. - Results are sorted by zone name. ## Compatibility SHOW ZONES is a DeltaForge extension. It queries the control plane catalog for top-level namespace containers, similar to SHOW DATABASES in traditional SQL systems.
-- List all zones
SHOW ZONES;-- Filter zones by name pattern
SHOW ZONES LIKE 'bronze%';-- Find zones whose names contain 'ext'
SHOW ZONES LIKE '%ext%';