Marketplace system tables reference

Preview

This system table is in Public Preview. To access the table, the schema must be enabled in your system catalog. For more information, see Enable system table schemas.

This article provides an overview of how to use system tables to help monitor your Databricks Marketplace selling process.

Marketplace system tables live in the system.marketplace schema. The following tables are available:

• Listing access: Records the consumer info for completed request data or get data events on your listings.
• Funnel events: Records impressions and actions taken on your listings.

note

You can use the Provider Analytics Dashboard to monitor recipient usage metrics. The dashboard pulls data from the Marketplace system tables. See Monitor listing usage metrics using dashboards.

Listing access events table

The listing access events table retrieves the consumer info for completed request data or get data events on your listings.

Table path: This system table is located at system.marketplace.listing_access_events.

Column name	Data type	Description
account_id	string	The account ID that hosts the listing.
metastore_id	string	The metatore ID that hosts the listing.
metastore_cloud	string	The cloud provider of the metastore that hosts the listing.
metastore_region	string	The region of the metastore that hosts the listing.
provider_id	string	The provider profile ID.
provider_name	string	The provider profile name.
listing_id	string	The listing ID.
listing_name	string	The listing name.
consumer_delta_sharing_recipient_name	string	The underlying Delta Sharing recipient name for the consumer. The value is null when the event_type is REQUEST_DATA.
consumer_delta_sharing_recipient_type	string	Whether the consumer is on a Databricks account or not. Values will be either OPEN or DATABRICKS.
consumer_cloud	string	The consumer's cloud. Nullable if consumer_delta_sharing_recipient_type is OPEN.
consumer_region	string	The consumer's region. Nullable if consumer_delta_sharing_recipient_type is OPEN.
consumer_metastore_id	string	The consumer's metastore ID. Nullable if consumer_delta_sharing_recipient_type is OPEN.
consumer_email	string	The consumer's email address.
consumer_name	string	The consumer's name.
consumer_company	string	The consumer's company.
consumer_intended_use	string	The consumer's intended use of the listing.
consumer_comments	string	Any additional comment the consumer left.
event_type	string	The type of access. The value can be either REQUEST_DATA or GET_DATA.
event_date	date	The UTC date the event happened.
event_time	timestamp	The exact UTC timestamp when the event happened. Timezone information is recorded at the end of the value with +00:00 representing UTC.

Listing funnel events table

The listing funnel events table analyzes impressions and actions taken on your listings. The event_type tells you what action the consumer took on your listing.

Table path: This system table is located at system.marketplace.listing_funnel_events.

Column name	Data type	Description
account_id	string	The account ID that hosts the listing.
metastore_id	string	The metatore ID that hosts the listing.
metastore_cloud	string	The cloud provider of the metastore that hosts the listing.
metastore_region	string	The region of the metastore that hosts the listing.
provider_id	string	The provider profile ID.
provider_name	string	The provider profile name.
listing_id	string	The listing ID.
listing_name	string	The listing name.
event_type	string	The type of consumer action. See Event types.
event_time	timestamp	The exact UTC timestamp when the event happened. Timezone information is recorded at the end of the value with +00:00 representing UTC.
event_date	date	The UTC date the event happened.
consumer_cloud	string	The consumer's cloud. Nullable if consumer_delta_sharing_recipient_type is OPEN.
consumer_region	string	The consumer's region. Nullable if consumer_delta_sharing_recipient_type is OPEN.

Event types

Possible values for the event_type column are:

• VIEW_LISTING
• START_REQUEST_DATA
• COMPLETE_REQUEST_DATA
• ABANDON_REQUEST_DATA
• START_GET_DATA
• COMPLETE_GET_DATA
• ABANDON_GET_DATA
• UNINSTALL_DATA
• FAIL_REQUEST_DATA
• FAIL_GET_DATA

Known limitations

• As of March 12, 2024, Marketplace system tables include activity from consumers using Databricks on Google Cloud. Tables do not include Google Cloud consumer activity prior to this date.
• In the listing_funnel_events table, the event types of ABANDON_FAIL_DATA and FAIL_GET_DATA were not recorded prior to November 30, 2023.

Example queries

This section includes the following sample queries you can use to gain insight into consumer activity on your listings.

• Consumer requests from the last 10 days
• Top listings by number of requests
• View top requesters
• View the number of times each consumer action was taken on a listing

Consumer requests from the last 10 days

SQL

SELECT event_date, provider_name, listing_name, listing_id, consumer_delta_sharing_recipient_name, consumer_cloud, consumer_region, consumer_name, consumer_email, consumer_company
FROM system.marketplace.listing_access_events
WHERE event_type = 'REQUEST_DATA'
AND event_date >= date_add(current_date(), -10)

Top listings by number of requests

SQL

SELECT listing_name, consumer_cloud, count(*) as requestCount
FROM system.marketplace.listing_access_events
GROUP BY listing_name, consumer_cloud
ORDER BY requestCount DESC

View top requesters

SQL

SELECT consumer_name, consumer_email, count(*) as requestCount
FROM system.marketplace.listing_access_events
GROUP BY consumer_name, consumer_email
ORDER BY requestCount DESC

View the number of times each consumer action was taken on a listing

SQL

SELECT event_type, COUNT(*) as occurrences
FROM system.marketplace.listing_funnel_events
WHERE listing_name = :listing_name
GROUP BY event_type

Notebook demo: Analyze the Marketplace system tables

The following notebook includes the examples queries from this article along with additional cells that provide further analysis.

Marketplace system table demo

Open notebook in new tab