Skip to main content

workspace_iam_v2

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

Overview

Nameworkspace_iam_v2
TypeResource
Iddatabricks_workspace.iamv2.workspace_iam_v2

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_detail_localselectprincipal_id, deployment_nameviewReturns the access details for a principal in the current workspace. Allows for checking access
resolve_group_proxyexecdeployment_name, external_idResolves a group with the given external ID from the customer's IdP. If the group does not exist, it
resolve_service_principal_proxyexecdeployment_name, external_idResolves an SP with the given external ID from the customer's IdP. If the SP does not exist, it will
resolve_user_proxyexecdeployment_name, 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
deployment_namestringThe Databricks Workspace Deployment Name (default: dbc-abcd0123-a1bc)
principal_idintegerRequired. The internal ID of the principal (user/sp/group) for which the access details are being requested.
viewstringControls what fields are returned.

SELECT examples

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

SELECT
account_id,
principal_id,
workspace_id,
access_type,
permissions,
principal_type,
status
FROM databricks_workspace.iamv2.workspace_iam_v2
WHERE principal_id = '{{ principal_id }}' -- required
AND deployment_name = '{{ deployment_name }}' -- 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_workspace.iamv2.workspace_iam_v2.resolve_group_proxy 
@deployment_name='{{ deployment_name }}' --required
@@json=
'{
"external_id": "{{ external_id }}"
}'
;