Creates a new zone, the top-level namespace container in the catalog.
CREATE ZONE [IF NOT EXISTS] <name> [TYPE '<type>'] [STORAGE_ROOT = '<path>'] [COMMENT '<desc>']## Overview Creates a zone in the catalog. Zones are the top-level containers in the DeltaForge three-level namespace (zone.schema.table). They typically represent stages in a data lake architecture, such as bronze (raw), silver (cleansed), and gold (aggregated). Zones provide organizational and governance boundaries. Permissions can be granted at the zone level and inherited by all schemas and tables within it. ## Behavior - Zone names must be unique across the account. - If IF NOT EXISTS is specified and the zone already exists (409 Conflict from the control plane), the statement completes successfully without modification. - If IF NOT EXISTS is omitted and the zone already exists, the command returns an error. - The TYPE field is advisory metadata. It does not enforce storage layout or processing rules. - STORAGE_ROOT is recorded as metadata. It serves as the default path prefix when creating tables within the zone. - The command is routed through the control plane catalog API. A valid catalog router connection is required. - The creating principal is recorded as the zone owner. ## Compatibility CREATE ZONE is a DeltaForge extension. Zones serve the same organizational role as top-level databases in traditional SQL systems, but they are tightly integrated with the DeltaForge catalog and permission model.
-- Create a minimal zone
CREATE ZONE bronze;-- Create a zone only if it does not already exist
CREATE ZONE IF NOT EXISTS silver;-- Create a zone with a type and storage root
CREATE ZONE gold TYPE gold STORAGE_ROOT = 's3://data-lake/gold' COMMENT 'Business-ready aggregated data';-- Set up a full medallion architecture
CREATE ZONE IF NOT EXISTS bronze COMMENT 'Raw ingestion landing zone';
CREATE ZONE IF NOT EXISTS silver COMMENT 'Cleansed and conformed zone';
CREATE ZONE IF NOT EXISTS gold COMMENT 'Curated analytics zone';-- Create an external zone for third-party data
CREATE ZONE IF NOT EXISTS external_feeds TYPE external STORAGE_ROOT = 's3://vendor-data/feeds' COMMENT 'Vendor CSV and JSON files';