consumer_listings

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

Overview

Name	consumer_listings
Type	Resource
Id	databricks_workspace.marketplace.consumer_listings

Fields

The following fields are returned by SELECT queries:

get

Name	Datatype	Description
▶listing	object

list

Name	Datatype	Description
id	string
▶detail	object
▶summary	object

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	id, deployment_name		Get a published listing in the Databricks Marketplace that the consumer has access to.
list	select	deployment_name	assets, categories, is_free, is_private_exchange, is_staff_pick, page_size, page_token, provider_ids, tags	List all published listings in the Databricks Marketplace that the consumer has access to.
batch_get	exec	deployment_name	ids	Batch get a published listing in the Databricks Marketplace that the consumer has access to.
search	exec	query, deployment_name	assets, categories, is_free, is_private_exchange, page_size, page_token, provider_ids	Search published listings in the Databricks Marketplace that the consumer has access to. This query

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)
id	string
query	string	Fuzzy matches query
assets	array	Matches any of the following asset types
categories	array	Matches any of the following categories
ids	array
is_free	boolean
is_private_exchange	boolean
is_staff_pick	boolean	Filters each listing based on whether it is a staff pick.
page_size	integer
page_token	string
provider_ids	array	Matches any of the following provider ids
tags	array	Matches any of the following tags

SELECT examples

get

Get a published listing in the Databricks Marketplace that the consumer has access to.

SELECT
listing
FROM databricks_workspace.marketplace.consumer_listings
WHERE id = '{{ id }}' -- required
AND deployment_name = '{{ deployment_name }}' -- required
;

list

List all published listings in the Databricks Marketplace that the consumer has access to.

SELECT
id,
detail,
summary
FROM databricks_workspace.marketplace.consumer_listings
WHERE deployment_name = '{{ deployment_name }}' -- required
AND assets = '{{ assets }}'
AND categories = '{{ categories }}'
AND is_free = '{{ is_free }}'
AND is_private_exchange = '{{ is_private_exchange }}'
AND is_staff_pick = '{{ is_staff_pick }}'
AND page_size = '{{ page_size }}'
AND page_token = '{{ page_token }}'
AND provider_ids = '{{ provider_ids }}'
AND tags = '{{ tags }}'
;

Lifecycle Methods

batch_get

Batch get a published listing in the Databricks Marketplace that the consumer has access to.

EXEC databricks_workspace.marketplace.consumer_listings.batch_get 
@deployment_name='{{ deployment_name }}' --required, 
@ids='{{ ids }}'
;

search

Search published listings in the Databricks Marketplace that the consumer has access to. This query

EXEC databricks_workspace.marketplace.consumer_listings.search 
@query='{{ query }}' --required, 
@deployment_name='{{ deployment_name }}' --required, 
@assets='{{ assets }}', 
@categories='{{ categories }}', 
@is_free={{ is_free }}, 
@is_private_exchange={{ is_private_exchange }}, 
@page_size='{{ page_size }}', 
@page_token='{{ page_token }}', 
@provider_ids='{{ provider_ids }}'
;