Schema:: DATA_SHARING_USAGE

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 listing.
Consumer installs a Snowflake Native App.
Consumer requests unlimited access to a limited trial listing or a free listing where data is not yet available.
Consumer installs the trial data product for a paid listing or limited trial listing.
Consumer buys a paid listing from the Snowflake Marketplace.
Consumer decides to no longer use the paid data for a paid listing.
Consumer uninstalls a Snowflake Native App or drops an imported database.

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, such as the Snowflake Marketplace.
EVENT_TYPE	VARCHAR	One of: `GET`: Consumer creates a database for a free listing, or installs a Snowflake Native App. `REQUEST`: Consumer requests a “by request” (personalized) listing, a limited trial listing, or a free listing that’s in a region where the data isn’t yet available. `TRIAL`: Consumer creates a trial database or installs a trial Snowflake Native App. `PURCHASE`: Consumer agrees to be invoiced when paid data in a paid listing is queried. `CANCEL PURCHASE`: Consumer decides to stop using the paid data in a paid listing. `UNINSTALL`: Consumer uninstalls a Snowflake Native App or drops an imported database.
SNOWFLAKE_REGION	VARCHAR	Snowflake Region where the `REQUEST` or `GET` event occurred.
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. Unique for each listing and is used to create the listing URL.
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	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 listing terms.
CONSUMER_METADATA	VARIANT	Other information included by the consumer when the event happened, such as their name or the reason for using a free email address.
REGION_GROUP	VARCHAR	Region group where the account of the consumer is located.
CONSUMER_NAME	VARCHAR	Contains the company name of the consumer account that accessed, used, or requested a listing. If a name is unavailable, such as for trial accounts, the value is NULL.
ACCESS_TYPE	VARCHAR	The listing access type. The access type is also called the monetization type.
EVENT_TIMESTAMP	DATETIME	The date and time that a listing-related event occurred.

Usage notes¶

Latency for the view may be up to 2 days.
The data is retained for 365 days (1 year).
The view contains data for all data products, whether your data product is a Snowflake Native App or a share.

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