Skip to main content

rfa

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

Overview​

Namerfa
TypeResource
Iddatabricks_workspace.catalog.rfa

Fields​

The following fields are returned by SELECT queries:

NameDatatypeDescription
full_namestringThe full name of the securable. Redundant with the name in the securable object, but necessary for Terraform integration
are_any_destinations_hiddenbooleanIndicates whether any destinations are hidden from the caller due to a lack of permissions. This value is true if the caller does not have permission to see all destinations.
β–Άdestination_source_securableobjectGeneric definition of a securable, which is uniquely defined in a metastore by its type and full<br /> name.
β–ΆdestinationsarrayThe access request destinations for the securable.
β–ΆsecurableobjectGeneric definition of a securable, which is uniquely defined in a metastore by its type and full<br /> name.
securable_typestringThe type of the securable. Redundant with the type in the securable object, but necessary for Terraform integration

Methods​

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
get_destinationsselectsecurable_type, full_name, deployment_nameGets an array of access request destinations for the specified securable. Any caller can see URL
batch_createinsertdeployment_nameCreates access requests for Unity Catalog permissions for a specified principal on a securable object.
update_destinationsupdateupdate_mask, deployment_name, access_request_destinationsUpdates the access request destinations for the given securable. The caller must be a metastore admin,

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)
full_namestringThe full name of the securable.
securable_typestringThe type of the securable.
update_maskstringThe field mask must be a single string, with multiple fields separated by commas (no spaces). The field path is relative to the resource object, using a dot (.) to navigate sub-fields (e.g., author.given_name). Specification of elements in sequence or map fields is not allowed, as only the entire collection field can be specified. Field names must exactly match the resource field names. A field mask of * indicates full replacement. It’s recommended to always explicitly list the fields being updated and avoid using * wildcards, as it can lead to unintended results if the API changes in the future.

SELECT examples​

Gets an array of access request destinations for the specified securable. Any caller can see URL

SELECT
full_name,
are_any_destinations_hidden,
destination_source_securable,
destinations,
securable,
securable_type
FROM databricks_workspace.catalog.rfa
WHERE securable_type = '{{ securable_type }}' -- required
AND full_name = '{{ full_name }}' -- required
AND deployment_name = '{{ deployment_name }}' -- required
;

INSERT examples​

Creates access requests for Unity Catalog permissions for a specified principal on a securable object.

INSERT INTO databricks_workspace.catalog.rfa (
requests,
deployment_name
)
SELECT
'{{ requests }}',
'{{ deployment_name }}'
RETURNING
responses
;

UPDATE examples​

Updates the access request destinations for the given securable. The caller must be a metastore admin,

UPDATE databricks_workspace.catalog.rfa
SET
access_request_destinations = '{{ access_request_destinations }}'
WHERE
update_mask = '{{ update_mask }}' --required
AND deployment_name = '{{ deployment_name }}' --required
AND access_request_destinations = '{{ access_request_destinations }}' --required
RETURNING
full_name,
are_any_destinations_hidden,
destination_source_securable,
destinations,
securable,
securable_type;