CREATE GROUP

Applies to: check marked yes Databricks SQL Databricks Runtime

Creates a workspace-local group with the specified name, optionally including a list of users and groups.

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;