temporary_table_credentials
Creates, updates, deletes, gets or lists a temporary_table_credentials
resource.
Overview
Name | temporary_table_credentials |
Type | Resource |
Id | databricks_workspace.unitycatalog.temporary_table_credentials |
Fields
The following fields are returned by SELECT
queries:
- generatetemporarytablecredentials
Request completed successfully.
Name | Datatype | Description |
---|---|---|
aws_temp_credentials | object | |
azure_user_delegation_sas | object | |
expiration_time | integer | |
gcp_oauth_token | object | |
r2_temp_credentials | object | |
url | string |
Methods
The following methods are available for this resource:
Name | Accessible by | Required Params | Optional Params | Description |
---|---|---|---|---|
generatetemporarytablecredentials | select | deployment_name | Get 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. |
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) |
SELECT
examples
- generatetemporarytablecredentials
Get 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
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 }}' -- required;