Organization Usage¶

Snowflake provides historical usage data for all accounts in your organization via the ORGANIZATION_USAGE schema in a shared database named SNOWFLAKE.

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¶

The ORGANIZATION_USAGE schema is available in the organization account and a regular account that has the ORGADMIN role enabled. How you access the views in the schema differs depending on which type of account you are using. For details about accessing views, see the following:

• Access schema in the organization account
• Access schema in an ORGADMIN-enabled account

Access schema in the organization account¶

By default, only users granted the GLOBALORGADMIN role can access ORGANIZATION_USAGE views in the organization account.

To grant access to other users, the organization administrator can grant the appropriate application role to an account role or user.

Users who have been granted the SNOWFLAKE.ORG_USAGE_ADMIN application role can access all views in the ORGANIZATION_USAGE schema of the organization account. The following example lets user joe access all views in the schema:

USE ROLE GLOBALORGADMIN;

GRANT APPLICATION ROLE SNOWFLAKE.ORG_USAGE_ADMIN TO ROLE custom_role;

GRANT ROLE custom_role TO USER joe;

The organization administrator can also grant access on a more granular level. For example, the ORGANIZATION_OBJECT_VIEWER application role grants access to the DATABASES view but does not grant access to the TASK_HISTORY view.

Use the following list to determine which application role grants access to a specific view. These application roles are in the SNOWFLAKE application. Use the fully qualified name of the application role when granting it to another role (for example, SNOWFLAKE.ORGANIZATION_USAGE_VIEWER).

Access schema in an ORGADMIN-enabled account¶

An ORGADMIN-enabled account is a regular account that has the ORGADMIN role enabled. Within a ORGADMIN-enabled 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, see Enabling other roles to use schemas in the SNOWFLAKE database.

To grant access to non-administrators, the organization administrator can grant the appropriate database role to an account role or user.

Using the following list to determine which database role grants access to specific views.

For more information, refer to GRANT DATABASE ROLE.

General usage notes¶