Skip to main content

account_iam

Creates, updates, deletes, gets or lists an account_iam resource.

Overview

Nameaccount_iam
TypeResource
Iddatabricks_account.iamv2.account_iam

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
account_idstringThe account ID parent of the workspace where the principal has access.
principal_idintegerThe internal ID of the principal (user/sp/group) in Databricks.
workspace_idintegerThe workspace ID where the principal has access.
access_typestringThe type of access the principal has to the workspace. (DIRECT, INDIRECT)
permissionsarrayThe permissions granted to the principal in the workspace.
principal_typestringThe type of the principal (user/sp/group). (GROUP, SERVICE_PRINCIPAL, USER)
statusstringThe activity status of the principal in the workspace. Not applicable for groups at the moment. (ACTIVE, INACTIVE)

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
get_workspace_access_detailselectaccount_id, workspace_id, principal_idviewReturns the access details for a principal in a workspace. Allows for checking access details for any
resolve_groupexecaccount_id, external_idResolves a group with the given external ID from the customer's IdP. If the group does not exist, it
resolve_service_principalexecaccount_id, external_idResolves an SP with the given external ID from the customer's IdP. If the SP does not exist, it will
resolve_userexecaccount_id, external_idResolves a user with the given external ID from the customer's IdP. If the user 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.

NameDatatypeDescription
account_idstring
principal_idintegerRequired. The internal ID of the principal (user/sp/group) for which the access details are being requested.
workspace_idintegerRequired. The workspace ID for which the access details are being requested.
viewstringControls what fields are returned.

SELECT examples

Returns the access details for a principal in a workspace. Allows for checking access details for any

SELECT
account_id,
principal_id,
workspace_id,
access_type,
permissions,
principal_type,
status
FROM databricks_account.iamv2.account_iam
WHERE account_id = '{{ account_id }}' -- required
AND workspace_id = '{{ workspace_id }}' -- required
AND principal_id = '{{ principal_id }}' -- required
AND view = '{{ view }}'
;

Lifecycle Methods

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

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