Skip to main content

account_access_identity_rules

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

Overview

Nameaccount_access_identity_rules
TypeResource
Iddatabricks_account.iamv2.account_access_identity_rules

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
namestringFully qualified name for the rule. Format: accounts/{account_id}/account-access-identity-rules/{external_principal_id}
external_principal_idstringExternal ID of the principal in the customer's IdP.
display_namestringDisplay name of the principal.
actionstringCurrently, only DENY action is supported. (DENY)
principal_typestringThe type of the principal (user/service principal/group). This field is populated by the server based on the external_principal_id. (GROUP, SERVICE_PRINCIPAL, USER)

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectparent, external_principal_idGets an account access identity rule for a given principal.
listselectparentfilter, page_size, page_tokenLists all account access identity rules for a given account. These rules control which principals
createinsertparent, external_principal_id, account_access_identity_ruleCreates a new account access identity rule for a given account. This allows administrators to
deletedeleteparent, external_principal_idDeletes an account access identity rule for a given 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
external_principal_idstringRequired. The external ID of the principal whose rule should be deleted.
parentstringRequired. The account for which to delete the rule. Format: accounts/{account_id}
filterstringOptional. Filter to apply to the list. Supports filtering by displayName.
page_sizeintegerOptional. The maximum number of rules to return. The service may return fewer than this value.
page_tokenstringOptional. A page token, received from a previous call. Provide this to retrieve the subsequent page.

SELECT examples

Gets an account access identity rule for a given principal.

SELECT
name,
external_principal_id,
display_name,
action,
principal_type
FROM databricks_account.iamv2.account_access_identity_rules
WHERE parent = '{{ parent }}' -- required
AND external_principal_id = '{{ external_principal_id }}' -- required
;

INSERT examples

Creates a new account access identity rule for a given account. This allows administrators to

INSERT INTO databricks_account.iamv2.account_access_identity_rules (
account_access_identity_rule,
parent,
external_principal_id
)
SELECT
'{{ account_access_identity_rule }}' /* required */,
'{{ parent }}',
'{{ external_principal_id }}'
RETURNING
name,
external_principal_id,
display_name,
action,
principal_type
;

DELETE examples

Deletes an account access identity rule for a given principal.

DELETE FROM databricks_account.iamv2.account_access_identity_rules
WHERE parent = '{{ parent }}' --required
AND external_principal_id = '{{ external_principal_id }}' --required
;