experiment_permissions
Operations on a experiment_permissions
resource.
Overview
Name | experiment_permissions |
Type | Resource |
Id | databricks_workspace.machinelearning.experiment_permissions |
Fields
Name | Datatype |
---|---|
access_control_list | array |
object_id | string |
object_type | string |
Methods
Name | Accessible by | Required Params | Description |
---|---|---|---|
getpermissions | SELECT | experiment_id, deployment_name | Gets the permissions of an experiment. Experiments can inherit permissions from their root object. |
updatepermissions | UPDATE | experiment_id, deployment_name | Updates the permissions on an experiment. Experiments can inherit permissions from their root object. |
setpermissions | REPLACE | experiment_id, deployment_name | Sets permissions on an object, replacing existing permissions if they exist. Deletes all direct permissions if none are specified. Objects can inherit permissions from their root object. |
SELECT
examples
SELECT
access_control_list,
object_id,
object_type
FROM databricks_workspace.machinelearning.experiment_permissions
WHERE experiment_id = '{{ experiment_id }}' AND
deployment_name = '{{ deployment_name }}';
UPDATE
example
Updates a experiment_permissions
resource.
/*+ update */
-- replace field1, field2, etc. with the fields you want to update
UPDATE databricks_workspace.machinelearning.experiment_permissions
SET field1 = '{{ value1 }}',
field2 = '{{ value2 }}', ...
WHERE experiment_id = '{{ experiment_id }}' AND
deployment_name = '{{ deployment_name }}';
REPLACE
example
Replaces a experiment_permissions
resource.
/*+ update */
-- replace field1, field2, etc. with the fields you want to update
REPLACE databricks_workspace.machinelearning.experiment_permissions
SET field1 = '{ value1 }',
field2 = '{ value2 }', ...
WHERE experiment_id = '{{ experiment_id }}' AND
deployment_name = '{{ deployment_name }}';