Sep 08, 2026: New ORGANIZATION_USAGE premium views¶

The ORGANIZATION_USAGE schema now includes 26 new premium views that are available in the organization account. These views provide visibility into governance policies, contacts, data classification, storage and pruning, Snowpipe Streaming, replication, tasks, and other object metadata across all accounts in your organization.

The new views are:

• AGGREGATION_POLICIES: Lists the aggregation policies defined in each account in your organization.
• CATALOG_LINKED_DATABASE_USAGE_HISTORY: Returns credit usage for catalog-linked databases in each account over the last 12 months.
• COLUMN_QUERY_PRUNING_HISTORY: Helps you understand data access patterns during query execution, including column-level pruning details.
• CONTACT_REFERENCES: Returns one row for each association between a contact and an object.
• CONTACTS: Returns one row for each contact in an account.
• DATA_CLASSIFICATION_HISTORY: Returns historical sensitive data classification results for each table over the last 365 days.
• DATA_CLASSIFICATION_LATEST: Returns one row for the most recent classification result for each classified table.
• DYNAMIC_TABLE_REFRESH_HISTORY: Returns dynamic table refresh history for accounts in your organization.
• HYBRID_TABLES: Returns one row for each hybrid table in an account.
• INDEX_COLUMNS: Returns one row for each column in an index in an account.
• INDEXES: Returns one row for each index in an account.
• JOIN_POLICIES: Returns one row for each join policy in an account.
• NOTEBOOKS_CONTAINER_RUNTIME_HISTORY: Returns hourly credit usage for notebooks running on Snowpark Container Services.
• OBJECT_ACCESS_REQUEST_HISTORY: Returns audit history for object access request submission, approval, and rejection.
• PRIVACY_POLICIES: Returns one row for each privacy policy in an account.
• PROJECTION_POLICIES: Returns one row for each projection policy in an account.
• REPLICATION_GROUPS: Returns one row for each replication or failover group in an account.
• SEARCH_OPTIMIZATION_BENEFITS: Helps you determine the efficacy of pruning due to search optimization.
• SNOWPIPE_STREAMING_CHANNEL_HISTORY: Returns a historical record of Snowpipe Streaming channel metrics such as data volume, errors, and latency.
• SNOWPIPE_STREAMING_CLIENT_HISTORY: Returns Snowpipe Streaming client load activity for the last 365 days.
• SNOWPIPE_STREAMING_FILE_MIGRATION_HISTORY: Returns Snowpipe Streaming file migration history for the last 365 days.
• STORAGE_USAGE: Returns average daily storage usage in bytes for each account for the last 365 days.
• TABLE_DML_HISTORY: Helps you determine the magnitude and effects of DML operations performed on tables.
• TABLE_PRUNING_HISTORY: Helps you determine the efficiency of pruning for all tables.
• TABLE_QUERY_PRUNING_HISTORY: Helps you understand data access patterns during query execution at the table level.
• TASKS: Returns one row for each task in an account.

For more information about accessing premium views in the organization account, see Access schema in the organization account.