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