provider_exchange_listings

Operations on a provider_exchange_listings resource.

Overview

Name	provider_exchange_listings
Type	Resource
Id	databricks_workspace.marketplace.provider_exchange_listings

Fields

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

Methods

Name	Accessible by	Required Params	Description
listexchangesforlisting	SELECT	listing_id, deployment_name	List exchanges associated with a listing
listlistingsforexchange	SELECT	exchange_id, deployment_name	List listings associated with an exchange
addlistingtoexchange	INSERT	deployment_name	Associate an exchange with a listing
deletelistingfromexchange	DELETE	id, deployment_name	Disassociate an exchange with a listing

SELECT examples

provider_exchange_listings (listexchangesforlisting)

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

provider_exchange_listings (listlistingsforexchange)

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

INSERT example

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

provider_exchange_listings

/*+ create */
INSERT INTO databricks_workspace.marketplace.provider_exchange_listings (
deployment_name,
data__listing_id,
data__exchange_id
)
SELECT 
'{{ deployment_name }}',
'{{ listing_id }}',
'{{ exchange_id }}'
;

Manifest

- name: your_resource_model_name
  props:
  - name: listing_id
    value: string
  - name: exchange_id
    value: string

DELETE example

Deletes a provider_exchange_listings resource.

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