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 limited trial listing or a free listing in a region where the data is not 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 no name is available, such as for trial accounts, the value is NULL.

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
Copy