Schema:

DATA_SHARING_USAGE

MONETIZED_USAGE_DAILY View

The MONETIZED_USAGE_DAILY view in the DATA_SHARING_USAGE schema lets you query the history of daily consumer queries per listing, including charges accumulated for the usage. To retrieve consumer payment information, query the MARKETPLACE_DISBURSEMENT_REPORT view in the ORGANIZATION_USAGE or DATA_SHARING_USAGE schema.

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

Columns

Column Name

Data Type

Description

REPORT_DATE

DATETIME

Date when the report was run.

USAGE_DATE

DATE

Usage date.

LISTING_NAME

VARCHAR

SQL identifier for the listing.

LISTING_DISPLAY_NAME

VARCHAR

Display name for the listing.

LISTING_GLOBAL_NAME

VARCHAR

Global name for the listing.

CONSUMER_ACCOUNT_LOCATOR

VARCHAR

Account locator of the consumer account.

CONSUMER_ACCOUNT_NAME

VARCHAR

Name of the consumer account.

CONSUMER_ORGANIZATION_NAME

VARCHAR

Organization name of the consumer account.

CONSUMER_SNOWFLAKE_REGION

VARCHAR

Cloud service region where the consumer account is hosted.

PRICING_PLAN

JSON

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.

Additional values are part of preview functionality:

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

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 free queries or usage after the maximum total charge for the month is reached, the value is 0.

GROSS_CHARGE

DECIMAL

Total charge for this line item on this day.

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 number of queries run and the total gross charges by customer and month. Queries are returned as number of units:

SELECT
  DATE_TRUNC(MONTH, usage_date) AS usage_month
, consumer_organization_name
, consumer_snowflake_region
, consumer_account_locator
, consumer_account_name
, currency
, SUM(units) AS units
, SUM(gross_charge) AS gross_charge
FROM snowflake.data_sharing_usage.monetized_usage_daily
GROUP BY 1,2,3,4,5,6;
Copy

Retrieve the total number of queries run and the total gross charges by listing and month:

SELECT
  DATE_TRUNC(MONTH, usage_date) AS usage_month
, listing_name
, listing_display_name
, listing_global_name
, currency
, SUM(units) AS units
, SUM(gross_charge) AS gross_charge
FROM snowflake.data_sharing_usage.monetized_usage_daily
GROUP BY 1,2,3,4,5;
Copy

Retrieve the total number of queries run and the total gross charges by charge type, consumer, and month:

SELECT
  DATE_TRUNC(MONTH, usage_date) AS usage_month
, consumer_organization_name
, consumer_snowflake_region
, consumer_account_locator
, consumer_account_name
, charge_type
, currency
, SUM(units) AS units
, SUM(gross_charge) AS gross_charge
FROM snowflake.data_sharing_usage.monetized_usage_daily
GROUP BY 1,2,3,4,5,6,7;
Copy