workspace_bindings

Operations on a workspace_bindings resource.

Overview

Name	workspace_bindings
Type	Resource
Id	databricks_workspace.unitycatalog.workspace_bindings

Fields

Name	Datatype
binding_type	string
workspace_id	integer

Methods

Name	Accessible by	Required Params	Description
getbindings	SELECT	securable_name, securable_type, deployment_name	Gets workspace bindings of the securable. The caller must be a metastore admin or an owner of the securable.
update	UPDATE	name, deployment_name	Updates workspace bindings of the catalog. The caller must be a metastore admin or an owner of the catalog.
updatebindings	UPDATE	securable_name, securable_type, deployment_name	Updates workspace bindings of the securable. The caller must be a metastore admin or an owner of the securable.

SELECT examples

SELECT
binding_type,
workspace_id
FROM databricks_workspace.unitycatalog.workspace_bindings
WHERE securable_name = '{{ securable_name }}' AND
securable_type = '{{ securable_type }}' AND
deployment_name = '{{ deployment_name }}';

UPDATE example

Updates a workspace_bindings resource.

update

/*+ update */
-- replace field1, field2, etc. with the fields you want to update        
UPDATE databricks_workspace.unitycatalog.workspace_bindings
SET field1 = '{{ value1 }}',
field2 = '{{ value2 }}', ...
WHERE name = '{{ name }}' AND
deployment_name = '{{ deployment_name }}';

updatebindings

/*+ update */
-- replace field1, field2, etc. with the fields you want to update        
UPDATE databricks_workspace.unitycatalog.workspace_bindings
SET field1 = '{{ value1 }}',
field2 = '{{ value2 }}', ...
WHERE securable_name = '{{ securable_name }}' AND
securable_type = '{{ securable_type }}' AND
deployment_name = '{{ deployment_name }}';