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 or the Snowflake Marketplace to which the listing belongs.

EVENT_DATE

DATETIME

Date of all UI interactions for a record.

SNOWFLAKE_REGION

VARCHAR

Snowflake region where the event occurred.

LISTING_NAME

VARCHAR

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

Back to top