Skip to main content

provider_listings

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

Overview

Nameprovider_listings
TypeResource
Iddatabricks_workspace.marketplace.provider_listings

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
listingobject

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectid, deployment_nameGet a listing
listselectdeployment_namepage_size, page_tokenList listings owned by this provider
createinsertdeployment_name, listingCreate a new listing
updatereplaceid, deployment_name, listingUpdate a listing
deletedeleteid, deployment_nameDelete a listing

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)
idstring
page_sizeinteger
page_tokenstring

SELECT examples

Get a listing

SELECT
listing
FROM databricks_workspace.marketplace.provider_listings
WHERE id = '{{ id }}' -- required
AND deployment_name = '{{ deployment_name }}' -- required
;

INSERT examples

Create a new listing

INSERT INTO databricks_workspace.marketplace.provider_listings (
listing,
deployment_name
)
SELECT
'{{ listing }}' /* required */,
'{{ deployment_name }}'
RETURNING
listing_id
;

REPLACE examples

Update a listing

REPLACE databricks_workspace.marketplace.provider_listings
SET
listing = '{{ listing }}'
WHERE
id = '{{ id }}' --required
AND deployment_name = '{{ deployment_name }}' --required
AND listing = '{{ listing }}' --required
RETURNING
listing;

DELETE examples

Delete a listing

DELETE FROM databricks_workspace.marketplace.provider_listings
WHERE id = '{{ id }}' --required
AND deployment_name = '{{ deployment_name }}' --required
;