Skip to main content

provider_exchanges

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

Overview

Nameprovider_exchanges
TypeResource
Iddatabricks_workspace.marketplace.provider_exchanges

Fields

The following fields are returned by SELECT queries:

Request completed successfully.

NameDatatypeDescription
idstring
namestring
commentstring
created_atinteger
created_bystring
filtersarray
linked_listingsarray
updated_atinteger
updated_bystring

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectdeployment_nameGet an exchange.
listselectdeployment_nameList exchanges visible to provider
createinsertdeployment_nameCreate an exchange
updateupdatedeployment_nameUpdate an exchange
deletedeletedeployment_nameThis removes a listing from marketplace.

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)

SELECT examples

Get an exchange.

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 }}' -- required;

INSERT examples

Create an exchange

INSERT INTO databricks_workspace.marketplace.provider_exchanges (
data__exchange,
deployment_name
)
SELECT
'{{ exchange }}',
'{{ deployment_name }}'
RETURNING
exchange_id
;

UPDATE examples

Update an exchange

UPDATE databricks_workspace.marketplace.provider_exchanges
SET
data__exchange = '{{ exchange }}'
WHERE
deployment_name = '{{ deployment_name }}' --required
RETURNING
exchange;

DELETE examples

This removes a listing from marketplace.

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