Skip to main content

provider_listings

Operations on a provider_listings resource.

Overview

Nameprovider_listings
TypeResource
Iddatabricks_workspace.marketplace.provider_listings

Fields

NameDatatype
idstring
detailobject
summaryobject

Methods

NameAccessible byRequired ParamsDescription
getSELECTid, deployment_nameGet a listing
listSELECTdeployment_nameList listings owned by this provider
createINSERTdeployment_nameCreate a new listing
deleteDELETEid, deployment_nameDelete a listing
updateUPDATEid, deployment_nameUpdate a listing

SELECT examples

SELECT
id,
detail,
summary
FROM databricks_workspace.marketplace.provider_listings
WHERE deployment_name = '{{ deployment_name }}';

INSERT example

Use the following StackQL query and manifest file to create a new provider_listings resource.

/*+ create */
INSERT INTO databricks_workspace.marketplace.provider_listings (
deployment_name,
data__listing
)
SELECT
'{{ deployment_name }}',
'{{ listing }}'
;

UPDATE example

Updates a provider_listings resource.

/*+ update */
-- replace field1, field2, etc. with the fields you want to update
UPDATE databricks_workspace.marketplace.provider_listings
SET field1 = '{{ value1 }}',
field2 = '{{ value2 }}', ...
WHERE id = '{{ id }}' AND
deployment_name = '{{ deployment_name }}';

DELETE example

Deletes a provider_listings resource.

/*+ delete */
DELETE FROM databricks_workspace.marketplace.provider_listings
WHERE id = '{{ id }}' AND
deployment_name = '{{ deployment_name }}';