Skip to main content

providers

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

Overview

Nameproviders
TypeResource
Iddatabricks_workspace.marketplace.providers

Fields

The following fields are returned by SELECT queries:

Request completed successfully.

NameDatatypeDescription
idstring
namestring
dark_mode_icon_file_idstring
icon_file_idstring
business_contact_emailstring
company_website_linkstring
dark_mode_icon_file_pathstring
descriptionstring
icon_file_pathstring
is_featuredboolean
privacy_policy_linkstring
published_bystring
support_contact_emailstring
term_of_service_linkstring

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
listselectdeployment_nameList provider profiles for account.
getselectdeployment_nameGet provider profile
createinsertdeployment_nameCreate a provider
updateupdatedeployment_nameUpdate provider profile
deletedeletedeployment_nameDelete provider

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

List provider profiles for account.

SELECT
id,
name,
dark_mode_icon_file_id,
icon_file_id,
business_contact_email,
company_website_link,
dark_mode_icon_file_path,
description,
icon_file_path,
is_featured,
privacy_policy_link,
published_by,
support_contact_email,
term_of_service_link
FROM databricks_workspace.marketplace.providers
WHERE deployment_name = '{{ deployment_name }}' -- required;

INSERT examples

Create a provider

INSERT INTO databricks_workspace.marketplace.providers (
data__provider,
deployment_name
)
SELECT
'{{ provider }}',
'{{ deployment_name }}'
RETURNING
id
;

UPDATE examples

Update provider profile

UPDATE databricks_workspace.marketplace.providers
SET
data__provider = '{{ provider }}'
WHERE
deployment_name = '{{ deployment_name }}' --required
RETURNING
provider;

DELETE examples

Delete provider

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