Skip to main content

groups

Creates, updates, deletes, gets or lists a groups resource.

Overview

Namegroups
TypeResource
Iddatabricks_account.iam.groups

Fields

The following fields are returned by SELECT queries:

Group information was returned successfully.

NameDatatypeDescription
idstring
displayNamestring
externalIdstring
membersarray
rolesarray

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectGets the information for a specific group in the Databricks account.
listselectGets all details of the groups associated with the Databricks account.
createinsertCreates a group in the Databricks account with a unique name, using the supplied group details.
patchupdatePartially updates the details of a group.
updatereplaceUpdates the details of a group by replacing the entire group entity.
deletedeleteDeletes a group from the Databricks account.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription

SELECT examples

Gets the information for a specific group in the Databricks account.

SELECT
id,
displayName,
externalId,
members,
roles
FROM databricks_account.iam.groups;

INSERT examples

Creates a group in the Databricks account with a unique name, using the supplied group details.

INSERT INTO databricks_account.iam.groups (
data__id,
data__displayName,
data__externalId,
data__members,
data__roles
)
SELECT
{{ id }},
'{{ displayName }}',
'{{ externalId }}',
'{{ members }}',
'{{ roles }}'
;

UPDATE examples

Partially updates the details of a group.

UPDATE databricks_account.iam.groups
SET
data__schemas = '{{ schemas }}',
data__Operations = '{{ Operations }}'
WHERE
;

REPLACE examples

Updates the details of a group by replacing the entire group entity.

REPLACE databricks_account.iam.groups
SET
data__id = {{ id }},
data__displayName = '{{ displayName }}',
data__externalId = '{{ externalId }}',
data__members = '{{ members }}',
data__roles = '{{ roles }}'
WHERE
;

DELETE examples

Deletes a group from the Databricks account.

DELETE FROM databricks_account.iam.groups;