Marketplace system table reference
Preview
This feature is in Public Preview.
This article provides an overview of how to use system tables to help operationalize your Databricks Marketplace selling process.
Marketplace system tables will all live in the system.marketplace
schema. Currently, the schema hosts the listing_access_events
table. This table retrieves the consumer info for completed request data or get data events on your listings.
Listing access events schema
This is the schema used in the listing_access_events
system table:
Column name |
Data type |
Description |
---|---|---|
|
string |
The account ID that hosts the listing. |
|
string |
The metatore ID that hosts the listing. |
|
string |
The cloud provider of the metastore that hosts the listing. |
|
string |
The region of the metastore that hosts the listing. |
|
string |
The provider profile ID. |
|
string |
The provider profile name. |
|
string |
The listing ID. |
|
string |
The listing name. |
|
string |
The underlying Delta Sharing recipient name for the consumer. The value is |
|
string |
Whether the consumer is on a Databricks account or not. Values will be either |
|
string |
The consumer’s cloud. Nullable if |
|
string |
The consumer’s region. Nullable if |
|
string |
The consumer’s metastore ID. Nullable if |
|
string |
The consumer’s email address. PII. |
|
string |
The consumer’s name. PII. |
|
string |
The consumer’s company. |
|
string |
The consumer’s intended use of the listing. |
|
string |
Any additional comment the consumer left. |
|
string |
The type of access. The value can be either |
|
date |
The UTC date the event happened. |
|
timestamp |
The exact UTC timestamp when the event happened. |
Known limitations
Listings created in a Google Cloud metastore are not logged in Marketplace system tables.
Activity from consumers using Databricks on Google Cloud is not logged in Marketplace system tables.
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)