Schema:

BILLING

COLLABORATION_REBATE_CONTRIBUTION view

The COLLABORATION_REBATE_CONTRIBUTION view in the BILLING schema shows how each consuming customer contributes to a provider organization’s monthly collaboration rebate.

Access

RequirementDetails
DatabaseSNOWFLAKE
SchemaBILLING
Database roleSNOWFLAKE.ORGANIZATION_BILLING_VIEWER

Access requires the ORGANIZATION_BILLING_VIEWER database role on the SNOWFLAKE shared database.

-- Grant the database role to a user role
GRANT DATABASE ROLE SNOWFLAKE.ORGANIZATION_BILLING_VIEWER TO ROLE <role_name>;

-- Query the view
USE ROLE <role_name>;
SELECT * FROM SNOWFLAKE.BILLING.COLLABORATION_REBATE_CONTRIBUTION LIMIT 10;

Columns

Column NameData TypeDescription
PROVIDER_ORGANIZATION_NAMEVARCHARName of the data provider’s Snowflake organization.
PROVIDER_ACCOUNT_LOCATORVARCHAR

Unique identifier (locator) for the provider’s Snowflake account whose shared data was consumed.

PROVIDER_ACCOUNT_NAMEVARCHAR

Human-readable alias of the provider’s Snowflake account, as shown in Snowsight.

CUSTOMER_NAMEVARCHAR

Name of the consuming customer whose compute on the provider’s shared data contributed to the rebate.

REBATE_CONTRIBUTION_PCTNUMBER

Percentage of the provider organization’s total monthly collaboration rebate attributable to this consumer’s usage of the provider’s shared data.

REBATE_DATEDATE

Date on which the rebate credit is applied (UTC). For a provider account that is active at month end, this is the last day of the rebate month. For an account whose contract terminated within the month, this is the contract’s termination date. If an account transitions between contracts mid-month, two rows appear: one with the termination date of the old contract and one with the last day of the rebate month for the new contract.

Usage notes

  • Latency for the view may be up to 24 hours after month close (typically on the 3rd or 4th day of the next month).