- Schema:
CONTRACT_ITEMS View¶
The CONTRACT_ITEMS view in the ORGANIZATION_USAGE schema can be used to return the contract information for an organization.
Columns¶
Column Name |
Data Type |
Description |
|---|---|---|
ORGANIZATION_NAME |
VARCHAR |
Name of the organization. |
CONTRACT_NUMBER |
VARCHAR |
Snowflake contract number for the organization. |
START_DATE |
DATE |
The start date for the Snowflake contract or the date the CONTRACT_ITEM goes into effect for the organization. |
END_DATE |
DATE |
The end date for the Snowflake contract or the date the CONTRACT_ITEM stops being used for the organization. |
EXPIRATION_DATE |
DATE |
The expiration date for the Snowflake contract or the date after which either the Renewal Contract goes into effect if signed within 30 days or the Snowflake relationship is terminated. |
CONTRACT_ITEM |
VARCHAR |
One of capacity, additional capacity, or free usage. |
CURRENCY |
VARCHAR |
The currency for the CONTRACT_ITEM. |
AMOUNT |
NUMBER (26,4) |
The amount for the CONTRACT_ITEM. |
CONTRACT_MODIFIED_DATE |
DATE |
The date (in the UTC timezone) the CONTRACT_ITEM was last modified. |
Usage Notes¶
Latency for the view may be up to 24 hours.
This view shows only the active contract for the organization.
Customers who signed a contract through a Snowflake reseller cannot access data in this view.
This view is accessible only by a user with the ORGADMIN role.