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 operationalize 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.

system.marketplace.listing_access_events has the following schema:

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. PII.

consumer_name

string

The consumer’s name. PII.

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.

system.marketplace.listing_funnel_events has the following schema:

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

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

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

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

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