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 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
-
The name of the workspace-local group to be created.
-
A user to include as a member of the group.
-
A workspace-local subgroup to include as a member of the group.
Examples
SQL
-- 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;