Warehouse Performance Dashboard

Gain insights into the performance and efficiency of a Snowflake warehouse over time with the Warehouse performance dashboard. Explore performance trends and identify opportunities to optimize warehouse configurations, enhancing performance and cost-effectiveness.

Roles for viewing dashboards:

• Tenant admin
• Snowflake admin
• Snowflake owner
• Snowflake viewer
• Snowflake approver 1 & 2
  ℹ️

  The org determines which objects a user can access in Slingshot. When a role is assigned to the parent org, the role has access to all of its child units.

Warehouse performance dashboard widgets

1. Query Load: the average query load per hour, per day of the week
2. Queued Queries: the average number of queries queued for each hour, each day of the week
3. Idleness: shows a trend of warehouse inactivity and suspension events over time (This visualization leverages data based on the auto-suspend settings of your warehouse.)
4. Query Size Classification: the total number of queries categorized by their respective run times
   ℹ️

   This widget is only available to the Tenant admin.
   • Small: Less than 1 minute
   • Medium: Less than 5 minutes
   • Large: More than 5 minutes
5. Data Spillage: the average amount of data spelled to disk per hour, per day of the week during query execution
   ℹ️

   This widget is only available to the Tenant admin.

Export/view summary data for deeper analysis

To access these insights,

1. From the left navigation, go to Dashboards, then to Warehouse performance.
2. Select a warehouse from the list.
3. Enter or select a date range from the calendar.
4. Review your warehouse performance metrics.

View or export summary data

Sometimes, you’d like to see a summary or need to download the insights information.

1. Hover over a visual, 3 dots appear.
2. Click the dots to see the options.
3. Select View summary data to review the summary on the page.
4. Or select Export to CSV to generate a file with the insights.