CREATE GROUP

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime

Creates a workspace-local group with the specified name, optionally including a list of users and groups. Workspace-local groups are not synchronized to the Databricks account and are not compatible with Unity Catalog. For more information, see Manage workspace-local groups (legacy).

Syntax

CREATE GROUP group_principal
  [ WITH
    [ USER user_principal [, ...] ]
    [ GROUP subgroup_principal [, ...] ]
  ]

Parameters

Examples

-- Create an empty group.
CREATE GROUP humans;

-- Create tv_aliens with Alf and Thor as members.
CREATE GROUP tv_aliens WITH USER `alf@melmak.et`, `thor@asgaard.et`;

-- Create aliens with Hilo and tv_aliens as members.
CREATE GROUP aliens WITH USER `hilo@jannus.et` GROUP tv_aliens;