Skip to main content

transitive_parent_groups

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

Overview

Nametransitive_parent_groups
TypeResource
Iddatabricks_workspace.iamv2.transitive_parent_groups

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
account_idstringThe parent account ID for group in Databricks.
external_idstringExternalId of the group in the customer's IdP.
internal_idstringInternal group ID of the group in Databricks.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
listselectprincipal_id, deployment_namepage_size, page_tokenLists all transitive parent groups of a principal.

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
deployment_namestringThe Databricks Workspace Deployment Name (default: dbc-abcd0123-a1bc)
principal_idintegerRequired. Internal ID of the principal in Databricks whose transitive parent groups are being listed.
page_sizeintegerThe maximum number of parent groups to return. The service may return fewer than this value. If not provided, defaults to 1000 (also the maximum allowed).
page_tokenstringA page token, received from a previous ListTransitiveParentGroups call. Provide this to retrieve the subsequent page.

SELECT examples

Lists all transitive parent groups of a principal.

SELECT
account_id,
external_id,
internal_id
FROM databricks_workspace.iamv2.transitive_parent_groups
WHERE principal_id = '{{ principal_id }}' -- required
AND deployment_name = '{{ deployment_name }}' -- required
AND page_size = '{{ page_size }}'
AND page_token = '{{ page_token }}'
;