provider_exchange_listings

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

Overview

Name	provider_exchange_listings
Type	Resource
Id	databricks_workspace.marketplace.provider_exchange_listings

Fields

The following fields are returned by SELECT queries:

listlistingsforexchange

Request completed successfully.

Name	Datatype	Description
id	string
exchange_id	string
listing_id	string
exchange_name	string
listing_name	string
created_at	integer
created_by	string

listexchangesforlisting

Request completed successfully.

Name	Datatype	Description
id	string
exchange_id	string
listing_id	string
exchange_name	string
listing_name	string
created_at	integer
created_by	string

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
listlistingsforexchange	select	deployment_name		List listings associated with an exchange
listexchangesforlisting	select	deployment_name		List exchanges associated with a listing
addlistingtoexchange	insert	deployment_name		Associate an exchange with a listing
deletelistingfromexchange	delete	deployment_name		Disassociate an exchange with 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.

Name	Datatype	Description
deployment_name	string	The Databricks Workspace Deployment Name (default: dbc-abcd0123-a1bc)

SELECT examples

listlistingsforexchange

List listings associated with an exchange

SELECT
id,
exchange_id,
listing_id,
exchange_name,
listing_name,
created_at,
created_by
FROM databricks_workspace.marketplace.provider_exchange_listings
WHERE deployment_name = '{{ deployment_name }}' -- required;

listexchangesforlisting

List exchanges associated with a listing

SELECT
id,
exchange_id,
listing_id,
exchange_name,
listing_name,
created_at,
created_by
FROM databricks_workspace.marketplace.provider_exchange_listings
WHERE deployment_name = '{{ deployment_name }}' -- required;

INSERT examples

addlistingtoexchange

Associate an exchange with a listing

INSERT INTO databricks_workspace.marketplace.provider_exchange_listings (
data__listing_id,
data__exchange_id,
deployment_name
)
SELECT 
'{{ listing_id }}',
'{{ exchange_id }}',
'{{ deployment_name }}'
RETURNING
exchange_for_listing
;

Manifest

# Description fields are for documentation purposes
- name: provider_exchange_listings
  props:
    - name: deployment_name
      value: string
      description: Required parameter for the provider_exchange_listings resource.
    - name: listing_id
      value: required
    - name: exchange_id
      value: string

DELETE examples

deletelistingfromexchange

Disassociate an exchange with a listing

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