Schema:: ORGANIZATION_USAGE

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: `FIXED`: Per-month charges. Also includes per-query charges if included by the provider in the pricing plan for the listing. `VARIABLE`: Per-query charges only.
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;

Copy

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;

Copy