Data Sharing Usage

In the SNOWFLAKE database, the DATA_SHARING_USAGE schema includes views that display information about listings published in the Snowflake Marketplace or a data exchange. This includes telemetry data (number of clicks), as well as consumption data (queries run by consumers).

Note

This data is available only to the account that published the individual listing. By default, only account administrators (users with the ACCOUNTADMIN role) in the account can access the SNOWFLAKE database and schemas within the database, or perform queries on the views; however, privileges on the database can be granted to other roles in your account to allow other users to access the objects. For more details, see Enabling Snowflake Database Usage for Other Roles.

DATA_SHARING_USAGE Views

The DATA_SHARING_USAGE schema contains the following views:

View

Type

Latency [1]

Notes

LISTING_TELEMETRY_DAILY

Historical

up to 2 days

Data retained for 1 year.

LISTING_EVENTS_DAILY

Historical

up to 2 days

Data retained for 1 year.

LISTING_CONSUMPTION_DAILY

Historical

up to 2 days

Data retained for 1 year.

LISTING_ACCESS_HISTORY

Historical

up to 2 days

Data retained for 1 year.

[1] All latency times are approximate; in some instances, the actual latency may be lower.

General Usage Notes

The Snowflake-specific views are subject to change. Avoid selecting all columns from these views. Instead, select the columns that you want. For example, if you want the name column, use SELECT name, rather than SELECT *.

Back to top