Organization Usage¶

ORGANIZATION_USAGE views¶

The ORGANIZATION_USAGE schema contains the following views:

_{[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.}

Accessing the ORGANIZATION_USAGE schema¶

To view data in the ORGANIZATION_USAGE schema, you must:

• Access the data from an account that has the ORGADMIN role enabled (i.e. the ORGADMIN account).

• Have the appropriate privileges to view the data. Within the ORGADMIN account, anyone who has access to the shared SNOWFLAKE database has access to the ORGANIZATION_USAGE schema. By default, only the ACCOUNTADMIN role has privileges to this database, which means the ORGADMIN role does not have the necessary privileges. To grant these privileges to the ORGADMIN role, refer to Enabling other roles to use schemas in the SNOWFLAKE database.

  To grant access to users who are not the account administrator or organization administrator, use a SNOWFLAKE database 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 *.