Monetization Usage Views¶
Snowflake provides historical usage data for paid listings as a set of views in the ORGANIZATION_USAGE and DATA_SHARING_USAGE schemas in the shared SNOWFLAKE database.
You can view historical usage data for other listings using the same ORGANIZATION_USAGE and DATA_SHARING_USAGE schemas, or view aggregated usage analytics in the Provider Studio. See About Monitoring Your Listing Usage.
In this Topic:
Monetization Usage Views in the ORGANIZATION_USAGE Schema¶
- Schema:
MARKETPLACE_DISBURSEMENT_REPORT View¶
The MARKETPLACE_DISBURSEMENT_REPORT view in the ORGANIZATION_USAGE schema lets you query the history of your earnings from paid listings in the Snowflake Marketplace.
The view includes the history for all accounts in your Snowflake organization.
Columns¶
Column Name |
Data Type |
Description |
---|---|---|
EVENT_DATE |
DATE |
Date when the payment event occurred. |
EVENT_TYPE |
VARCHAR |
Type of event (payment). |
INVOICE_DATE |
DATE |
Date of the invoice. |
LISTING_OWNER_ACCOUNT_NAME |
VARCHAR |
Name of the provider account that owns the listing. |
LISTING_OWNER_ACCOUNT_LOCATOR |
VARCHAR |
Account locator for the provider account that owns the listing. For more information about account identifiers, see account identifier. |
LISTING_NAME |
VARCHAR |
Identifier for the listing. |
LISTING_DISPLAY_NAME |
VARCHAR |
Display name of the listing. |
LISTING_GLOBAL_NAME |
VARCHAR |
Global name of the listing. |
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: |
GROSS |
DECIMAL |
Gross amount billed. |
FEES |
DECIMAL |
Pre-tax fees that Snowflake subtracted from the gross amount. |
TAXES |
DECIMAL |
Sales tax on the FEES column amount. |
NET_AMOUNT |
DECIMAL |
Actual amount to be paid to the provider. The price is calculated by subtracting fees and taxes from the gross amount paid by the consumer. |
CURRENCY |
VARCHAR |
USD |
Usage Notes¶
Latency for the view can be up to 24 hours (1 day).
The data is retained for 365 days (1 year).
Examples¶
Retrieve the total amount disbursed to a provider’s bank account for each month for each listing:
SELECT
event_date
, listing_name
, listing_display_name
, listing_global_name
, currency
, SUM(net_amount) AS net_amount
FROM snowflake.organization_usage.marketplace_disbursement_report
WHERE event_type = 'payment'
GROUP BY 1,2,3,4,5;
Retrieve the total amount that has been disbursed for each invoice period, grouped by listing and charge type. Note that the invoice period could be spread out over multiple report dates:
SELECT
invoice_date
, listing_name
, listing_display_name
, listing_global_name
, charge_type
, currency
, SUM(gross) AS gross
, SUM(fees) AS fees
, SUM(taxes) AS taxes
, SUM(net_amount) AS net_amount
FROM snowflake.organization_usage.marketplace_disbursement_report
WHERE event_type = 'payment'
GROUP BY 1,2,3,4,5,6;
MONETIZED_USAGE_DAILY View¶
The MONETIZED_USAGE_DAILY view in the ORGANIZATION_USAGE schema lets you query the history of daily consumer queries per data listing, including charges accumulated for the usage. Note that for 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 all accounts in your Snowflake organization.
Columns¶
Column Name |
Data Type |
Description |
---|---|---|
REPORT_DATE |
DATETIME |
Date when the report was run. |
USAGE_DATE |
DATE |
Usage date. |
LISTING_OWNER_ACCOUNT_NAME |
VARCHAR |
Name of the provider account that owns the listing. |
LISTING_OWNER_ACCOUNT_LOCATOR |
VARCHAR |
Account locator for the provider account that owns the listing. For more information about account identifiers, see account identifier. |
LISTING_NAME |
VARCHAR |
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: |
UNITS |
VARCHAR |
Number of queries included in the charge. For a |
UNIT_PRICE |
DECIMAL |
Per-month or per-query fee. For free queries or after the maximum total charge for the month is reached, the value is |
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 24 hours (1 day).
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.organization_usage.monetized_usage_daily
GROUP BY 1,2,3,4,5,6;
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.organization_usage.monetized_usage_daily
GROUP BY 1,2,3,4,5;
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.organization_usage.monetized_usage_daily
GROUP BY 1,2,3,4,5,6,7;
Monetization Usage Views in the DATA_SHARING_USAGE Schema¶
- Schema:
MARKETPLACE_DISBURSEMENT_REPORT View¶
The MARKETPLACE_DISBURSEMENT_REPORT view in the DATA_SHARING_USAGE schema lets you query the history of your earnings from paid listings in the Snowflake Marketplace.
The view includes the history for a specific listing.
Columns¶
Column Name |
Data Type |
Description |
---|---|---|
EVENT_DATE |
DATE |
Date when the payment event occurred. |
EVENT_TYPE |
VARCHAR |
Type of event (payment). |
INVOICE_DATE |
DATE |
Date of the invoice. |
LISTING_NAME |
VARCHAR |
Identifier for the listing. |
LISTING_DISPLAY_NAME |
VARCHAR |
Display name for the listing. |
LISITNG_GLOBAL_NAME |
VARCHAR |
Global name of the listing. |
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: |
GROSS |
DECIMAL |
Gross amount billed. |
FEES |
DECIMAL |
Pre-tax fees that Snowflake subtracted from the gross amount. |
TAXES |
DECIMAL |
Sales tax on the FEES column amount. |
NET_AMOUNT |
DECIMAL |
Actual amount to be paid to the provider. The price is calculated by subtracting fees and taxes from the gross amount paid by the consumer. |
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 disbursed to a provider’s bank account for each month for each listing:
SELECT
event_date
, listing_name
, listing_display_name
, listing_global_name
, currency
, SUM(net_amount) AS net_amount
FROM snowflake.data_sharing_usage.marketplace_disbursement_report
WHERE event_type = 'payment'
GROUP BY 1,2,3,4,5;
Retrieve the total amount that has been disbursed for each invoice period, grouped by listing and charge type. Note that the invoice period could be spread out over multiple report dates:
SELECT
invoice_date
, listing_name
, listing_display_name
, listing_global_name
, charge_type
, currency
, SUM(gross) AS gross
, SUM(fees) AS fees
, SUM(taxes) AS taxes
, SUM(net_amount) AS net_amount
FROM snowflake.data_sharing_usage.marketplace_disbursement_report
WHERE event_type = 'payment'
GROUP BY 1,2,3,4,5,6;
LISTING_EVENTS_DAILY View¶
The LISTING_EVENTS_DAILY view in the DATA_SHARING_USAGE schema lets you query the daily history of consumer activity on listings, including:
Consumer mounts a database from a free or personalized listing.
Consumer requests a personalized listing or a free listing where data is not yet available.
Consumer mounts the trial database for a paid listing.
Consumer buys a monetized listing. Note, they are not charged unless they query the data.
Consumer decides to no longer use the paid data for a monetized listing.
To retrieve listing usage statistics, query the MONETIZED_USAGE_DAILY view in the ORGANIZATION_USAGE or DATA_SHARING_USAGE schema.
The view includes the history of consumer activity for a specific listing.
Columns¶
Column Name |
Data Type |
Description |
---|---|---|
EVENT_DATE |
DATE |
Date of the event. |
EXCHANGE_NAME |
VARCHAR |
Name of the data exchange the listing belongs to. |
EVENT_TYPE |
VARCHAR |
|
SNOWFLAKE_REGION |
VARCHAR |
Snowflake region where the |
LISTING_NAME |
VARCHAR |
Identifier of the listing. |
LISTING_DISPLAY_NAME |
VARCHAR |
Display name of the listing. |
LISTING_GLOBAL_NAME |
VARCHAR |
Global name of the listing. |
CONSUMER_ACCOUNT_LOCATOR |
VARCHAR |
Account locator of the consumer account. For more information about account identifiers, see account identifier. |
CONSUMER_ACCOUNT_NAME |
VARCHAR |
Name of the consumer account. |
CONSUMER_ORGANIZATION_NAME |
VARCHAR |
Organization name of the consumer account. |
CONSUMER_EMAIL |
VARCHAR |
Email address for the consumer account (if available). |
CONSUMER_METADATA |
VARCHAR |
Other information included by the consumer when the event occurred. |
TERMS_ACCEPTED |
DATETIME |
Timestamp when the consumer accepted the terms of service. |
Usage Notes¶
Latency for the view can be up to 48 hours (2 days).
The data is retained for 365 days (1 year).
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: |
UNITS |
VARCHAR |
Number of queries included in the charge. For a |
UNIT_PRICE |
DECIMAL |
Per-month or per-query fee. For free queries or after the maximum total charge for the month is reached, the value is |
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;
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;
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;