Schema:

ORGANIZATION_USAGE

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.

  • This view is accessible only by a user with the ORGADMIN role.