Organization Hub Insights¶

The Insights page in Organization Hub presents organization-level metrics through interactive tiles that display trends, alerts, and summary data from all accounts in your organization. Use Insights to monitor and analyze cost, security posture, query health, and storage.

Insights requires an organization account with premium views enabled.

Get started¶

Use Snowsight to sign in to the organization account.
Switch to the GLOBALORGADMIN role, or to a role that has been granted the appropriate ORGANIZATION_USAGE application roles.
In the navigation menu, select Organization Hub » Insights.

High-level highlights¶

The top of Insights contains highlights from each section. Select a tile to switch to the corresponding tile further down the page.

Billing and Cost¶

The Billing and Cost section of Insights contains the following tiles:

Tile	Description
Total cost	Displays the total cost average cost per month for your organization. View a graph showing cost trends over time.
Cost by service type	Shows a breakdown of costs by different Snowflake service types, such as data quality monitoring, logging, and warehouses
Total storage	Displays the current total storage usage across your organization with percentage change over time. Shows storage breakdown by category, which can be one of the following: Active Retained for clone Time travel Failsafe
Contract utilization	Tracks your contract utilization percentage, showing total cost, remaining capacity on the contract, and any overage costs since the start of the contract.

Security¶

The Security section of Insights contains the following tiles:

Tile	Description
Trust center violations	Displays the total number of open Trust Center violations across your organization, grouped by severity level. Shows the percentage change from the previous week. Select Trust Center to open the Trust Center and drill down into the information.
Trust center scanner package coverage	Shows the percentage of accounts with Trust Center scanner packages enabled, excluding security essentials and extension packages (that is, custom-defined packages).
Strong Authentication progress	Tracks strong authentication readiness across your accounts, showing the number and percentage of accounts that are Strong Authentication ready versus not ready.
Login failures by type	Displays total login failures and the percentage change over the last 28 days, broken down by failure type.
Authentication methods (human)	Shows the distribution of authentication methods used by human users (that is, users of type PERSON).
Authentication methods (service)	Displays the authentication methods used by service users (that is, users of type SERVICE).
Account admins	Lists all accounts in the organization and the users who have the ACCOUNTADMIN role.
Security admins	Lists all accounts in the organization and the users who have the SECURITYADMIN role.
Dormant users	Shows the number of users with no logins in the last 3 months, with percentage change and a trend graph over time.

Query health¶

The Query health section of Insights contains the following tiles:

Tile	Description
Failed queries	Displays the total number of failed grouped queries with percentage change over time. Failed queries are categorized by error type. Queries are grouped by their parameterized hash The tile gathers its data from the QUERY_HISTORY view of the ORGANIZATION_USAGE schema.
Warehouse concurrency load	Shows queue wait times and queued load across warehouses, helping identify warehouses with the highest query queuing. Displays queue events, total queries, and queue rate per warehouse. The tile gathers its data from the WAREHOUSE_LOAD_HISTORY and QUERY_HISTORY views of the ORGANIZATION_USAGE schema.
Top grouped queries by cost	Lists the top grouped queries ordered by credits per query. Queries are grouped by their parameterized hash, showing the highest cost query patterns and percentage change over time. The tile gathers its data from the QUERY_HISTORY view of the ORGANIZATION_USAGE schema.
Warehouse load and queueing	Displays the average queued load across all warehouses with percentage change over time. Helps investigate overall warehouse congestion level, where higher values indicate more queries are waiting in queue. The tile gathers its data from the WAREHOUSE_LOAD_HISTORY view of the ORGANIZATION_USAGE schema.

Access control requirements¶

Users with the GLOBALORGADMIN role can access Insights. Designated users and roles that have been granted the appropriate ORGANIZATION_USAGE application roles can also access Insights. Those application roles include ORGANIZATION_BILLING_VIEWER for cost data, ORGANIZATION_SECURITY_VIEWER for security data, and ORGANIZATION_GOVERNANCE_VIEWER and ORGANIZATION_USAGE_VIEWER for query and warehouse data. For the full list, see Access schema in the organization account.

Command Center is documented separately and requires GLOBALORGADMIN. See Organization Command Center.

Analyze organization insights with Cortex Code¶

You can investigate organization-wide cost, security, and usage in Cortex Code without signing in to each account separately.

In Cortex Code (CLI, Desktop, or the Snowsight panel), type /organization-management to invoke the skill, then describe what you want to know. For more information, see organization-management.

Example prompts:

Give me a 30-day executive summary of all accounts in my organization, including costs, usage, and reliability.

Review our organization-wide security posture: MFA adoption, login failures, and authentication settings.

Analyze cross-account credit and storage spending trends for a quarterly business review.