Creates a workspace boundary for isolating user assets, scripts, and pipelines.
CREATE WORKSPACE [IF NOT EXISTS] <name> [COMMENT '<description>']
## Overview CREATE WORKSPACE registers a workspace in the catalog. Workspaces group together user-authored assets (scripts, pipelines, schedules, dashboards) and provide a unit of isolation for grants and quotas. ## Behavior - Workspace creation requires ACCOUNTADMIN. The Control Plane enforces the `ManageWorkspaces` privilege, which only ACCOUNTADMIN holds by default. - Storage configuration for the workspace (storage root, default zone) is managed through the Control Plane API; this SQL command captures only the name and comment. - Without IF NOT EXISTS, creating a workspace that already exists raises an error. ## Access Control Requires the `ManageWorkspaces` privilege (ACCOUNTADMIN by default). ## Compatibility DeltaForge extension.
| Name | Type | Description |
|---|---|---|
name | Specifies the workspace name. | |
comment | Optional human-readable description. | |
if_not_exists | When true, succeed silently if a workspace with this name already exists. |
CREATE WORKSPACE analytics_team;
CREATE WORKSPACE IF NOT EXISTS analytics_team COMMENT 'Analytics team sandbox';