provider_exchanges

Operations on a provider_exchanges resource.

Overview

Name	provider_exchanges
Type	Resource
Id	databricks_workspace.marketplace.provider_exchanges

Fields

Name	Datatype
id	string
name	string
comment	string
created_at	integer
created_by	string
filters	array
linked_listings	array
updated_at	integer
updated_by	string

Methods

Name	Accessible by	Required Params	Description
get	SELECT	id, deployment_name	Get an exchange.
list	SELECT	deployment_name	List exchanges visible to provider
create	INSERT	deployment_name	Create an exchange
delete	DELETE	id, deployment_name	This removes a listing from marketplace.
update	UPDATE	id, deployment_name	Update an exchange

SELECT examples

provider_exchanges (list)

SELECT
id,
name,
comment,
created_at,
created_by,
filters,
linked_listings,
updated_at,
updated_by
FROM databricks_workspace.marketplace.provider_exchanges
WHERE deployment_name = '{{ deployment_name }}';

provider_exchanges (get)

SELECT
id,
name,
comment,
created_at,
created_by,
filters,
linked_listings,
updated_at,
updated_by
FROM databricks_workspace.marketplace.provider_exchanges
WHERE id = '{{ id }}' AND
deployment_name = '{{ deployment_name }}';

INSERT example

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

provider_exchanges

/*+ create */
INSERT INTO databricks_workspace.marketplace.provider_exchanges (
deployment_name,
data__exchange
)
SELECT 
'{{ deployment_name }}',
'{{ exchange }}'
;

Manifest

- name: your_resource_model_name
  props:
  - name: exchange
    value:
      id: string
      name: string
      comment: string
      filters:
      - id: string
        exchange_id: string
        filter_value: string
        name: string
        created_at: 0
        created_by: string
        updated_at: 0
        updated_by: string
        filter_type: GLOBAL_METASTORE_ID
      created_at: 0
      created_by: string
      updated_at: 0
      updated_by: string
      linked_listings:
      - id: string
        exchange_id: string
        exchange_name: string
        listing_id: string
        listing_name: string
        created_at: 0
        created_by: string

UPDATE example

Updates a provider_exchanges resource.

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

DELETE example

Deletes a provider_exchanges resource.

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