Schema:

DATA_SHARING_USAGE

MARKETPLACE_PAID_USAGE_DAILY View

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 count of queries executed by your users on specific listings, with the charges for the usage.

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

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 identifier.

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: TRIAL_QUERIES: No charge. The queries were executed within the trial period for the listing. . FIXED_ONLY: Per-month charges only. . FIXED_PLUS: Per-month plus per-query charges. . FREE_QUERIES: 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 only. . MAX_REACHED: No charge. The queries were executed after the maximum total monthly cost for this listing was reached.

UNITS

VARCHAR

Number of queries included in the charge. For a FIXED charge, this value is 1.

UNIT_PRICE

DECIMAL

Per-month or per-query fee. For sample data, the value is 0.

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).

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;
Copy