Organization Usage¶
Snowflake provides historical usage data for all accounts in your organization via the ORGANIZATION_USAGE schema in a shared database named SNOWFLAKE. Users with the ORGADMIN or ACCOUNTADMIN role can access the ORGANIZATION_USAGE schema.
Important
By default, the ORGADMIN role does not have access to the shared SNOWFLAKE database, which prevents the organization administrator from accessing the ORGANIZATION_USAGE schema. The account administrator must grant the ORGADMIN role access to the SNOWFLAKE database before the organization administrator can use the ORGANIZATION_USAGE views. For instructions, see Enabling Snowflake Database Usage for Other Roles.
In this Topic:
ORGANIZATION_USAGE Views¶
The ORGANIZATION_USAGE schema contains the following views:
View |
Type |
Latency [1] |
Notes |
---|---|---|---|
Historical |
24 hours |
Data retained for 1 year. |
|
CONTRACT_ITEMS [2] |
Historical |
24 hours |
|
Historical |
2 hours |
Data retained for 1 year. |
|
Historical |
24 hours |
Data retained for 1 year. |
|
Historical |
24 hours |
Data retained for 1 year. |
|
Historical |
24 hours |
Data retained for 1 year. |
|
Historical |
24 hours |
Data retained for 1 year. |
|
Historical |
24 hours |
Data retained for 1 year. |
|
Historical |
2 hours |
Data retained for 1 year. |
|
Historical |
24 hours |
Data retained for 1 year. |
|
Historical |
24 hours |
Data retained for 1 year. |
|
RATE_SHEET_DAILY [2] |
Historical |
24 hours |
|
Historical |
72 hours |
||
Historical |
24 hours |
Data retained for 1 year. |
|
Historical |
24 hours |
Data retained for 1 year. |
|
Historical |
24 hours |
Data retained for 1 year. |
|
Historical |
2 hours |
Data retained for 1 year. |
|
Historical |
72 hours |
||
Historical |
24 hours |
Data retained for 1 year. |
[1] All latency times are approximate; in some instances, the actual latency may be lower.
[2] The organization billing views do not display the actual, final amount because some adjustments are made at the end of the month. Customers who signed a contract through a Snowflake reseller cannot access data in these views.
ORGANIZATION_USAGE Schema SNOWFLAKE Database Roles¶
The ORGANIZATION_USAGE_VIEWER and ORGANIZATION_BILLING_VIEWER SNOWFLAKE database roles are granted the SELECT privilege on find Organization Usage views in the shared SNOWFLAKE database.
View |
ORGANIZATION_BILLING_VIEWER Role |
ORGANIZATION_USAGE_VIEWER Role |
---|---|---|
✔ |
||
✔ |
||
✔ |
||
✔ |
||
✔ |
||
✔ |
||
✔ |
||
✔ |
||
✔ |
||
✔ |
||
✔ |
||
✔ |
||
✔ |
||
✔ |
||
✔ |
||
✔ |
||
✔ |
||
✔ |
||
✔ |
General Usage Notes¶
The Snowflake-specific views are subject to change. Avoid selecting all columns from these views. Instead, select the columns that you want.
For example, if you want the name
column, use SELECT name
, rather than SELECT *
.