- Schema:
LISTING_EVENTS_DAILY View¶
The LISTING_EVENTS_DAILY view in the DATA_SHARING_USAGE schema lets you query the daily history of consumer activity on listings for the Snowflake Marketplace and data exchanges, including:
Consumer installs a database from a free or personalized listing.
Consumer requests a personalized listing or a free listing where data is not yet available.
Consumer installs the trial database for a paid listing.
Consumer buys a paid listing from the Snowflake Marketplace.
Consumer decides to no longer use the paid data for a monetized listing.
The view includes the history of consumer activity for a specific listing.
Columns¶
Column Name |
Data Type |
Description |
---|---|---|
EVENT_DATE |
DATE |
Date of the event. |
EXCHANGE_NAME |
VARCHAR |
Name of the data exchange the listing belongs to. |
EVENT_TYPE |
VARCHAR |
|
SNOWFLAKE_REGION |
VARCHAR |
Snowflake region where the |
LISTING_NAME |
VARCHAR |
Identifier of the listing. |
LISTING_DISPLAY_NAME |
VARCHAR |
Display name of the listing. |
LISTING_GLOBAL_NAME |
VARCHAR |
Global name of the listing. |
CONSUMER_ACCOUNT_LOCATOR |
VARCHAR |
Account locator of the consumer account. For more information about account identifiers, see account identifier. |
CONSUMER_ACCOUNT_NAME |
VARCHAR |
Name of the consumer account. |
CONSUMER_ORGANIZATION_NAME |
VARCHAR |
Organization name of the consumer account. |
CONSUMER_EMAIL |
VARCHAR |
Email address for the consumer account (if available). |
TERMS_ACCEPTED_DATE |
DATETIME |
Timestamp when the consumer accepted the terms of service. |
CONSUMER_METADATA |
VARIANT |
Other information included by the consumer when the event happened, such as their name. |
REGION_GROUP |
VARCHAR |
Region group where the account of the consumer is located. |
Usage Notes¶
Latency for the view may be up to 2 days.
The data is retained for 365 days (1 year).
Examples¶
Shows daily count of gets and requests by listing:
SELECT
listing_name,
listing_display_name,
event_date,
event_type,
SUM(1) AS count_gets_requests
FROM snowflake.data_sharing_usage.listing_events_daily
GROUP BY 1,2,3,4