Skip to main content

temporary_table_credentials

Operations on a temporary_table_credentials resource.

Overview

Nametemporary_table_credentials
TypeResource
Iddatabricks_workspace.unitycatalog.temporary_table_credentials

Fields

NameDatatype
aws_temp_credentialsobject
azure_user_delegation_sasobject
expiration_timeinteger
gcp_oauth_tokenobject
r2_temp_credentialsobject
urlstring

Methods

NameAccessible byRequired ParamsDescription
generatetemporarytablecredentialsSELECTdeployment_nameGet a short-lived credential for directly accessing the table data on cloud storage. The metastore must have external_access_enabled flag set to true (default false). The caller must have EXTERNAL_USE_SCHEMA privilege on the parent schema and this privilege can only be granted by catalog owners.

SELECT examples

SELECT
aws_temp_credentials,
azure_user_delegation_sas,
expiration_time,
gcp_oauth_token,
r2_temp_credentials,
url
FROM databricks_workspace.unitycatalog.temporary_table_credentials
WHERE deployment_name = '{{ deployment_name }}';