Schema:: Data Sharing Usage

MARKETPLACE_PAID_USAGE_DAILY View¶

As a consumer, you can use the MARKETPLACE_PAID_USAGE_DAILY view in the Data Sharing Usage schema to query the daily history of your usage of a specific paid listing. Retrieve the charges for the usage and the count of queries executed by your users on specific listings.

This view includes the history of consumer payments for a specific listing.

Note

As part of the Offers preview, the value in the UNIT_PRICE column varies for current and preview functionality.

Columns¶

Column Name	Data Type	Description
REPORT_DATE	DATETIME	Date when the report was run.
USAGE_DATE	DATETIME	Usage date.
PROVIDER_NAME	VARCHAR	Provider display name from listing.
PROVIDER_ACCOUNT_NAME	VARCHAR	Account name of the provider.
PROVIDER_ACCOUNT_LOCATOR	VARCHAR	Account locator of the provider account. For more information about account identifiers, see Account identifiers.
PROVIDER_ORGANIZATION_NAME	VARCHAR	Organization name for the provider.
LISTING_DISPLAY_NAME	VARCHAR	Display name of the listing.
LISTING_GLOBAL_NAME	VARCHAR	Global name of the listing.
DATABASE_NAME	VARCHAR	Name of the database associated with this listing.
PO_NUMBER	VARCHAR	Purchase order number associated with this listing.
PRICING_PLAN	VARIANT	JSON value that includes the specifics of the pricing plan. Only included in the output for paid usage.
CHARGE_TYPE	VARCHAR	Type of charge assessed. For more information about the components of the pricing model for paid listings, see Paid Listings Pricing Models. Possible values: `SAMPLE`: No charge. The queries were executed within the trial period for the listing. `FIXED`: Per-month charges. `GRACE`: No charge. The queries were counted among the free queries allowed in the calendar month (after the first query) before the per-query charge is applied. `VARIABLE`: Per-query charges. `MAX_VARIABLE_USAGE_REACHED`: No charge. The queries were executed after the maximum total monthly cost for this listing was reached. `NON_MONETIZABLE_BILLING_EVENTS`: No charge. These billable events were emitted during trial usage of a data product, or for billable events not part of a pricing plan on the listing. `MONETIZABLE_BILLING_EVENTS`: Custom event billing charges. `MAX_BILLING_EVENT_USAGE_REACHED`: No charge. These billable events were emitted after the maximum total monthly cost for the listing was reached. Additional values are part of preview functionality: SPCS_COMPUTE_POOL_SURCHARGE: The amount of the SPCS compute pool surcharge. MAX_SPCS_COMPUTE_POOL_SURCHARGE_REACHED: No further charge. When the consumer ran additional queries, they had already reached the maximum total SPCS compute pool surcharge for this listing.
UNITS	VARCHAR	Number of queries included in the charge. For a `FIXED` charge, this value is `1`.
UNIT_PRICE	DECIMAL	Current functionality: The per-month or per-query fee. For sample data, the value is `0`. Preview functionality: The discounted price of the listing.
CHARGE	DECIMAL	Total charge for this line item on this day (without tax).
CURRENCY	VARCHAR	USD

Usage Notes¶

Latency for the view can be up to 48 hours (2 days).
The data is retained for 365 days (1 year).
You can only see the usage for your account, which must be the consumer account that generated the charges.

Examples¶

Retrieve the total amount charged per month and listing:

SELECT
  DATE_TRUNC(MONTH, usage_date) AS usage_month
, listing_display_name
, listing_global_name
, SUM(charge) AS charge
FROM snowflake.data_sharing_usage.marketplace_paid_usage_daily
GROUP BY 1,2,3;

Retrieve the total amount charged per month, listing, and type of charge:

SELECT
  DATE_TRUNC(MONTH, usage_date) AS usage_month
, listing_display_name
, listing_global_name
, SUM(charge) AS charge
, charge_type
FROM snowflake.data_sharing_usage.marketplace_paid_usage_daily
GROUP BY 1,2,3,4;

Retrieve the total amount charged for usage of an application that uses the Custom Event Billing pricing plan:

SELECT listing_global_name,
   listing_display_name,
   charge_type,
   charge
FROM SNOWFLAKE.DATA_SHARING_USAGE.MARKETPLACE_PAID_USAGE_DAILY
WHERE charge_type='MONETIZABLE_BILLING_EVENTS';