Data Consumers: Monetization Usage Views

Snowflake provides historical usage data for paid listings via a set of views in the ORGANIZATION_USAGE and DATA_SHARING_USAGE schemas in the shared SNOWFLAKE database.

In this Topic:

ORGANIZATION_USAGE Views

Schema:

ORGANIZATION_USAGE

MARKETPLACE_PAID_USAGE_DAILY View

The MARKETPLACE_PAID_USAGE_DAILY view in the ORGANIZATION_USAGE schema can be used to query the daily history of your usage of paid listings. Retrieve the count of queries executed by your users on individual listings, with the charges for the usage.

The view includes this history for all accounts in your Snowflake organization.

Note

The name of this view may change during the preview period.

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.

CONSUMER_ACCOUNT_NAME

VARCHAR

Name of the consumer account.

CONSUMER_ACCOUNT_LOCATOR

VARCHAR

Account locator of the consumer account. For more information about account identifiers, see account identifier.

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 Snowflake Marketplace Pricing Model. 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

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.organization_usage.marketplace_paid_usage_daily
GROUP BY 1,2,3;

Retrieve the total amount charged per month, listing, and consumer account:

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

DATA_SHARING_USAGE Views

Schema:

DATA_SHARING_USAGE

MARKETPLACE_PAID_USAGE_DAILY View

The MARKETPLACE_PAID_USAGE_DAILY view in the ORGANIZATION_USAGE schema can be used to query the daily history of your usage of paid listings. Retrieve the count of queries executed by your users on individual listings, with the charges for the usage.

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

Note

The name of this view may change during the preview period.

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 Snowflake Marketplace Pricing Model. 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

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;