- Schema:
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