groups

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

Overview

Name	groups
Type	Resource
Id	databricks_account.iamv2.groups

Fields

The following fields are returned by SELECT queries:

get

Name	Datatype	Description
account_id	string	The parent account ID for group in Databricks.
external_id	string	ExternalId of the group in the customer's IdP.
internal_id	string	Internal group ID of the group in Databricks.
group_name	string	Display name of the group.

list

Name	Datatype	Description
account_id	string	The parent account ID for group in Databricks.
external_id	string	ExternalId of the group in the customer's IdP.
internal_id	string	Internal group ID of the group in Databricks.
group_name	string	Display name of the group.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	account_id, internal_id		Fetches a group from the Databricks account by its internal ID.
list	select	account_id	filter, page_size, page_token	Lists the groups in the Databricks account, returning one page per call. Supports filtering by group
create	insert	account_id, group		Creates a group in the Databricks account and returns the resulting Group resource.
update	update	account_id, internal_id, update_mask, group		Updates an existing group in the Databricks account. Only the fields named in the update mask are
delete	delete	account_id, internal_id		Deletes a group from the Databricks account by its internal ID.
resolve	exec	account_id, external_id		Resolves a group with the given external ID from the customer's IdP. If the group does not exist, it

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.

Name	Datatype	Description
account_id	string
internal_id	string	Required. Internal ID of the group in Databricks.
update_mask	string	Optional. The list of fields to update.
filter	string	Optional. Allows filtering groups by group name or external id.
page_size	integer	The maximum number of groups to return. The service may return fewer than this value.
page_token	string	A page token, received from a previous ListGroups call. Provide this to retrieve the subsequent page.

SELECT examples

get

Fetches a group from the Databricks account by its internal ID.

SELECT
account_id,
external_id,
internal_id,
group_name
FROM databricks_account.iamv2.groups
WHERE account_id = '{{ account_id }}' -- required
AND internal_id = '{{ internal_id }}' -- required
;

list

Lists the groups in the Databricks account, returning one page per call. Supports filtering by group

SELECT
account_id,
external_id,
internal_id,
group_name
FROM databricks_account.iamv2.groups
WHERE account_id = '{{ account_id }}' -- required
AND filter = '{{ filter }}'
AND page_size = '{{ page_size }}'
AND page_token = '{{ page_token }}'
;

INSERT examples

create

Creates a group in the Databricks account and returns the resulting Group resource.

INSERT INTO databricks_account.iamv2.groups (
group,
account_id
)
SELECT 
'{{ group }}' /* required */,
'{{ account_id }}'
RETURNING
account_id,
external_id,
internal_id,
group_name
;

Manifest

# Description fields are for documentation purposes
- name: groups
props:
  - name: account_id
    value: "{{ account_id }}"
    description: Required parameter for the groups resource.
  - name: group
    description: |
      Required. Group to be created in <Databricks>
    value:
      account_id: "{{ account_id }}"
      external_id: "{{ external_id }}"
      group_name: "{{ group_name }}"
      internal_id: "{{ internal_id }}"

UPDATE examples

update

Updates an existing group in the Databricks account. Only the fields named in the update mask are

UPDATE databricks_account.iamv2.groups
SET 
group = '{{ group }}'
WHERE 
account_id = '{{ account_id }}' --required
AND internal_id = '{{ internal_id }}' --required
AND update_mask = '{{ update_mask }}' --required
AND group = '{{ group }}' --required
RETURNING
account_id,
external_id,
internal_id,
group_name;

DELETE examples

delete

Deletes a group from the Databricks account by its internal ID.

DELETE FROM databricks_account.iamv2.groups
WHERE account_id = '{{ account_id }}' --required
AND internal_id = '{{ internal_id }}' --required
;

Lifecycle Methods

resolve

Resolves a group with the given external ID from the customer's IdP. If the group does not exist, it

EXEC databricks_account.iamv2.groups.resolve 
@account_id='{{ account_id }}' --required 
@@json=
'{
"external_id": "{{ external_id }}"
}'
;