temporary_table_credentials

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

Overview

Name	temporary_table_credentials
Type	Resource
Id	databricks_workspace.catalog.temporary_table_credentials

Fields

The following fields are returned by SELECT queries:

SELECT not supported for this resource, use SHOW METHODS to view available operations for the resource.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
generate	insert	deployment_name		Get a short-lived credential for directly accessing the table data on cloud storage. The metastore

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.

Name	Datatype	Description
deployment_name	string	The Databricks Workspace Deployment Name (default: dbc-abcd0123-a1bc)

INSERT examples

generate

Get a short-lived credential for directly accessing the table data on cloud storage. The metastore

INSERT INTO databricks_workspace.catalog.temporary_table_credentials (
operation,
table_id,
deployment_name
)
SELECT 
'{{ operation }}',
'{{ table_id }}',
'{{ deployment_name }}'
RETURNING
aws_temp_credentials,
azure_aad,
azure_user_delegation_sas,
expiration_time,
gcp_oauth_token,
r2_temp_credentials,
url
;

Manifest

# Description fields are for documentation purposes
- name: temporary_table_credentials
props:
  - name: deployment_name
    value: "{{ deployment_name }}"
    description: Required parameter for the temporary_table_credentials resource.
  - name: operation
    value: "{{ operation }}"
    description: |
      The operation performed against the table data, either READ or READ_WRITE. If READ_WRITE is specified, the credentials returned will have write permissions, otherwise, it will be read only.
  - name: table_id
    value: "{{ table_id }}"
    description: |
      UUID of the table to read or write.