Schema:: DATA_SHARING_USAGE

LISTING_EVENTS_DAILY View¶

The LISTING_EVENTS_DAILY view in the DATA_SHARING_USAGE schema enables you to retrieve the history of completed requests or get events for the data exchange. A request event indicates that a consumer has successfully submitted a request for a listing. A get event indicates that a consumer has successfully created a database from the data associated with a listing.

Columns¶

Column Name	Data Type	Description
EVENT_DATE	DATETIME	Date of the event.
EXCHANGE_NAME	VARCHAR	Name of the data exchange the listing belongs to.
EVENT_TYPE	VARCHAR	Event type. Valid values are: CANCEL PURCHASE, GET, REQUEST, PURCHASE, and TRIAL. (Must be upper case.)
SNOWFLAKE_REGION	VARCHAR	Snowflake region where the request or get occurred.
LISTING_NAME	VARCHAR	SQL identifier for the listing.
LISTING_DISPLAY_NAME	VARCHAR	Display name of the listing.
LISTING_GLOBAL_NAME	VARCHAR	Listing global name.
CONSUMER_ACCOUNT_LOCATOR	VARCHAR	Consumer’s account locator name.
CONSUMER_ACCOUNT_NAME	VARCHAR	Consumer’s account name.
CONSUMER_ORGANIZATION	VARCHAR	Consumer’s organization name.
CONSUMER_EMAIL	VARCHAR	Consumer’s email (if available).
TERMS_ACCEPTED_DATE	DATETIME	Timestamp when the consumer accepted listing terms.
CONSUMER_METADATA	VARIANT	Other information included by the consumer when the event happened.
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

Copy