transitive_parent_groups

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

Overview

Name	transitive_parent_groups
Type	Resource
Id	databricks_account.iamv2.transitive_parent_groups

Fields

The following fields are returned by SELECT queries:

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.
group_id	string	Internal group ID of the group in Databricks.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
list	select	account_id, principal_id, account_host	page_size, page_token	Lists 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.

Name	Datatype	Description
account_host	string	The Databricks account console host. Selected by DATABRICKS_CLOUD (aws, azure or gcp; default aws), or set explicitly with DATABRICKS_ACCOUNT_HOST (bare host, no scheme). (default: accounts.cloud.databricks.com, x-stackQL-envVar: DATABRICKS_ACCOUNT_HOST, x-stackQL-envVarSelector: {"envVar":"DATABRICKS_CLOUD","default":"aws","values":{"aws":"accounts.cloud.databricks.com","azure":"accounts.azuredatabricks.net","gcp":"accounts.gcp.databricks.com"}})
account_id	string
principal_id	integer	Required. Internal ID of the principal in Databricks whose transitive parent groups are being listed.
page_size	integer	The maximum number of parent groups to return. The service may return fewer than this value. If not provided, defaults to 1000, which is also the maximum allowed. Requests for more than the maximum are clamped to 1000.
page_token	string	A page token, received from a previous ListTransitiveParentGroups call. Provide this to retrieve the subsequent page.

SELECT examples

list

Lists all transitive parent groups of a principal.

SELECT
account_id,
external_id,
group_id
FROM databricks_account.iamv2.transitive_parent_groups
WHERE account_id = '{{ account_id }}' -- required
AND principal_id = '{{ principal_id }}' -- required
AND account_host = '{{ account_host }}' -- required
AND page_size = '{{ page_size }}'
AND page_token = '{{ page_token }}'
;