View full changelog

Introducing Insights

Date
  • Niall Woodward
    Co-founder & CTO of SELECT

Snowflake users want to know whether they are using Snowflake efficiently. To help with this, we've historically highlighted optimization opportunities on the individual resources pages throughout SELECT. One of the downsides of this approach is that these opportunities are only discovered when a user navigates to the given page.

To help users instantly discover all the different Snowflake optimization opportunities in their account, we're excited to announce the release of a brand new feature called Insights. Insights live on a centralized page, accessible from the side bar.

Every day, SELECT intelligently scans all the different resources and workloads running in your account, and identifies the potential savings associated with a variety of different optimization opportunities. The "Overview" tab highlights your top optimization opportunities, showing the total savings potential, the estimated effort to implement this optimization, and the number of resources the insight applies to.

SELECT Insights feature part 1

In addition, we surface two other valuable datasets:

  1. The highest cost workloads in your account. Many users are unaware of which workloads (think dashboards, dbt models, or recurring query patterns) drive the most consumption. Users should regularly review their top workloads to ensure they are inline with expectations and providing more value than they cost.
  2. The workloads that increased the most in the given time period. This helps users spot workloads that have had a performance/cost regression, or new workloads that first surfaced in the given period.
SELECT Insights feature part 1

On the Insights "Explorer" tab, you can browse, filter and sort through all your optimization opportunities.

SELECT Insights feature part 1

Each row is clickable, and reveals an Insight detail card showing additional information about the insight, how the potential savings were calculated, and the estimated effort required to action this opportunity.

SELECT Insights feature part 1

We hope you enjoy the new feature. You can learn more in the Insights documentation.

Get up and running with SELECT in 15 minutes.

Automatically optimize, understand and monitor Snowflake usage

Gain visibility into Snowflake usage, optimize performance and automate savings with the click of a button.

SELECT web application screenshot

Want to get notified when we release new features? 
Subscribe to get notified.