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. To let another role query DATA_SHARING_USAGE views without granting access to the rest of the SNOWFLAKE database, grant the SNOWFLAKE.SHARING_USAGE_VIEWER database role. For more information, see DATA_SHARING_USAGE schema.
You can also grant privileges on the SNOWFLAKE database to other roles. For more details, see Enabling other roles to use schemas in the SNOWFLAKE database.
DATA_
The DATA_SHARING_USAGE schema contains the following views:
| View | Type | Latency [1] | Retention duration | View audience |
|---|---|---|---|---|
| APPLICATION_STATE | Current state | up to 10 minutes | Not applicable. | Provider |
| LISTING_ACCESS_HISTORY | Historical | up to 2 days | Data retained for 1 year. | Provider |
| LISTING_AUTO_FULFILLMENT_DATABASE_STORAGE_DAILY | Historical | up to 2 days | Data retained for 1 year. | Provider |
| LISTING_AUTO_FULFILLMENT_REFRESH_DAILY | Historical | up to 2 days | Data retained for 1 year. | Provider |
| LISTING_CONSUMPTION_DAILY | Historical | up to 2 days | Data retained for 1 year. | Provider |
| LISTING_EVENTS_DAILY | Historical | up to 2 days | Data retained for 1 year. | Provider |
| LISTING_TELEMETRY_DAILY | Historical | up to 2 days | Data retained for 1 year. | Provider |
| MARKETPLACE_DISBURSEMENT_REPORT | Historical | up to 2 days | Data retained for 1 year. | Provider |
| MARKETPLACE_LISTING_INVOICE_STATUS | Historical | up to 2 days | Data retained for 1 year. | Provider |
| MARKETPLACE_PAID_USAGE_DAILY | Historical | up to 2 days | Data retained for 1 year. | Consumer |
| MARKETPLACE_PROVIDER_SPCS_USAGE | Historical | up to 2 days | Data retained for 1 year. | Provider |
| MONETIZED_USAGE_DAILY | Historical | up to 2 days | Data retained for 1 year. | Provider |
| PAID_LISTING_ACCESS_AND_CHANGE_LOG | Historical | up to 2 days | Data retained for 1 year. | Provider |
| PROVIDER_APPLICATION_DAILY_USAGE_HISTORY | Historical | up to 2 days | Data retained for 1 year. | Provider |
| RESHARED_LISTING_CONSUMPTION_DAILY | Historical | up to 2 days | Data retained for 1 year. | Provider |
[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 *.