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 other roles to use schemas in the SNOWFLAKE database.

DATA_SHARING_USAGE views¶

The DATA_SHARING_USAGE schema contains the following views:

View	Type	Latency ^[1]	Retention duration
APPLICATION_STATE	Current state	up to 10 minutes	Not applicable.
LISTING_ACCESS_HISTORY	Historical	up to 2 days	Data retained for 1 year.
LISTING_AUTO_FULFILLMENT_DATABASE_STORAGE_DAILY	Historical	up to 2 days	Data retained for 1 year.
LISTING_AUTO_FULFILLMENT_REFRESH_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_EVENTS_DAILY	Historical	up to 2 days	Data retained for 1 year.
LISTING_TELEMETRY_DAILY	Historical	up to 2 days	Data retained for 1 year.
MARKETPLACE_DISBURSEMENT_REPORT	Historical	up to 2 days	Data retained for 1 year.
MARKETPLACE_LISTING_INVOICE_STATUS	Historical	up to 2 days	Data retained for 1 year.
MARKETPLACE_PAID_USAGE_DAILY	Historical	up to 2 days	Data retained for 1 year.
MONETIZED_USAGE_DAILY	Historical	up to 2 days	Data retained for 1 year.
PAID_LISTING_ACCESS_AND_CHANGE_LOG	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 *.