- 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. Only visible to providers of paid listings, this view includes the history of payment statuses per invoice for purchased listings.
Columns¶
Column Name |
Data Type |
Description |
---|---|---|
STRIPE_DISPLAY_NUMBER |
VARCHAR |
The Stripe invoice or display number. |
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 |
CONSUMER_ACCOUNT_NAME |
VARCHAR |
Name of the consumer account. |
CONSUMER_ACCOUNT_LOCATOR |
VARCHAR |
Account locator for the consumer account. |
CONSUMER_ORGANIZATION_NAME |
VARCHAR |
Name of the consumer organization. |
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;