CREATE GROUP (Databricks SQL)

Creates a 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

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;