CREATE GROUP

Applies to: Databricks SQL 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 Azure Databricks account and are not compatible with Unity Catalog. For more information, see Manage workspace-local groups (legacy).

To run this command you must be an administrator.

Syntax

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

Parameters

• group_principal

  The name of the workspace-local group to be created.

• user_principal

  A user to include as a member of the group.

• subgroup_principal

  A workspace-local subgroup to include as a member of the group.

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;

Related articles

• SHOW GROUPS
• ALTER GROUPS
• DROP GROUP
• principals