Schema:

DATA_SHARING_USAGE

LISTING_TELEMETRY_DAILY View

The LISTING_TELEMETRY_DAILY view in the DATA_SHARING_USAGE schema displays daily telemetry data by data exchange and region. The view returns a row for each data exchange in your organization, and each region where that data exchange is available.

Columns

Column Name

Data Type

Description

EXCHANGE_NAME

VARCHAR

Name of the data exchange the listing belongs to.

EVENT_DATE

DATETIME

Date of all UI interactions for a record.

SNOWFLAKE_REGION

VARCHAR

Snowflake region where the event 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.

EVENT_TYPE

VARCHAR

Get, request, or listing click.

ACTION

VARCHAR

Action that was taken on the event. For example, if the event was GET, then the actions could be STARTED or COMPLETED.

EVENT_COUNT

INTEGER

The total number of times this event action occurred on the event date.

CONSUMER_ACCOUNTS_DAILY

INTEGER

The count of distinct accounts that performed the given event action above.

CONSUMER_ACCOUNTS_28D

INTEGER

The count of distinct consumer accounts that performed the given event action in the past 28 days.

Usage Notes

  • Latency for the view may be up to 2 days.

  • The data is retained for 365 days (1 year).

Examples

Shows click-through rates for each listing:

SELECT
  listing_name,
  listing_display_name,
  event_date,
  SUM(IFF(event_type = 'listing click', consumer_accounts_daily, 0)) AS listing_clicks,
  SUM(IFF(event_type IN ('get', 'request') and action = 'started', consumer_accounts_daily, 0)) AS get_request_started,
  SUM(IFF(event_type IN ('get', 'request') and action = 'completed', consumer_accounts_daily, 0)) AS get_request_completed,
  get_request_completed / NULLIFZERO(listing_clicks) AS ctr
FROM snowflake.data_sharing_usage.LISTING_TELEMETRY_DAILY
GROUP BY 1,2,3
ORDER BY 1,2,3