Skip to main content

secret_acls

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

Overview​

Namesecret_acls
TypeResource
Iddatabricks_workspace.workspace.secret_acls

Fields​

The following fields are returned by SELECT queries:

NameDatatypeDescription
permissionstringThe permission level applied to the principal. (MANAGE, READ, WRITE)
principalstringThe principal in which the permission is applied.

Methods​

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectscope, principal, deployment_name, workspace_domainDescribes the details about the given ACL, such as the group and permission.
listselectscope, deployment_name, workspace_domainLists the ACLs set on the given scope.
putinsertdeployment_name, workspace_domain, scope, principal, permissionCreates or overwrites the ACL associated with the given principal (user or group) on the specified
deleteexecdeployment_name, workspace_domain, scope, principalDeletes the given ACL on the given scope.

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: the host prefix of the workspace URL (dbc-abcd0123-a1bc on AWS, adb-1234567890123456.7 on Azure, 1234567890123456.7 on GCP). Set DATABRICKS_DEPLOYMENT_NAME to default it for the session. (default: dbc-abcd0123-a1bc, x-stackQL-envVar: DATABRICKS_DEPLOYMENT_NAME)
principalstringThe principal to fetch ACL information for.
scopestringThe name of the scope to fetch ACL information from.
workspace_domainstringThe Databricks workspace domain suffix for the cloud. Selected by DATABRICKS_CLOUD (aws, azure or gcp; default aws). (default: cloud.databricks.com, x-stackQL-envVarSelector: {"envVar":"DATABRICKS_CLOUD","default":"aws","values":{"aws":"cloud.databricks.com","azure":"azuredatabricks.net","gcp":"gcp.databricks.com"}})

SELECT examples​

Describes the details about the given ACL, such as the group and permission.

SELECT
permission,
principal
FROM databricks_workspace.workspace.secret_acls
WHERE scope = '{{ scope }}' -- required
AND principal = '{{ principal }}' -- required
AND deployment_name = '{{ deployment_name }}' -- required
AND workspace_domain = '{{ workspace_domain }}' -- required
;

INSERT examples​

Creates or overwrites the ACL associated with the given principal (user or group) on the specified

INSERT INTO databricks_workspace.workspace.secret_acls (
scope,
principal,
permission,
deployment_name,
workspace_domain
)
SELECT
'{{ scope }}' /* required */,
'{{ principal }}' /* required */,
'{{ permission }}' /* required */,
'{{ deployment_name }}',
'{{ workspace_domain }}'
;

Lifecycle Methods​

Deletes the given ACL on the given scope.

EXEC databricks_workspace.workspace.secret_acls.delete
@deployment_name='{{ deployment_name }}' --required,
@workspace_domain='{{ workspace_domain }}' --required
@@json=
'{
"scope": "{{ scope }}",
"principal": "{{ principal }}"
}'
;