Skip to main content

provider_files

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

Overview

Nameprovider_files
TypeResource
Iddatabricks_workspace.marketplace.provider_files

Fields

The following fields are returned by SELECT queries:

Request completed successfully.

NameDatatypeDescription
idstring
display_namestring
created_atinteger
download_linkstring
file_parentobject
marketplace_file_typestring
mime_typestring
statusstring
status_messagestring
updated_atinteger

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectdeployment_nameGet a file
listselectdeployment_nameList files attached to a parent entity.
createinsertdeployment_nameCreate a file. Currently, only provider icons and attached notebooks are supported.
deletedeletedeployment_nameDelete a file

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)

SELECT examples

Get a file

SELECT
id,
display_name,
created_at,
download_link,
file_parent,
marketplace_file_type,
mime_type,
status,
status_message,
updated_at
FROM databricks_workspace.marketplace.provider_files
WHERE deployment_name = '{{ deployment_name }}' -- required;

INSERT examples

Create a file. Currently, only provider icons and attached notebooks are supported.

INSERT INTO databricks_workspace.marketplace.provider_files (
data__marketplace_file_type,
data__mime_type,
data__display_name,
data__file_parent,
deployment_name
)
SELECT
'{{ marketplace_file_type }}',
'{{ mime_type }}',
'{{ display_name }}',
'{{ file_parent }}',
'{{ deployment_name }}'
RETURNING
file_info,
upload_url
;

DELETE examples

Delete a file

DELETE FROM databricks_workspace.marketplace.provider_files
WHERE deployment_name = '{{ deployment_name }}' --required;