# Identifying Optimization Opportunities

URL: https://select.dev/docs/reference/usage-guide/identifying-optimization-opportunities
Index of all SELECT docs: https://select.dev/docs/llms.txt

> Learn how to use SELECT to find cost optimization opportunities.

[YouTube video](https://youtu.be/rSLA9gFbdfc)

In this guide, we will explain the primary ways users can find optimization opportunities in SELECT.

## Method 1: Use Insights

The easiest way to find optimization opportunities in SELECT is from the Insights page found in the left sidebar. Here you’ll get an overview of 6 highlighted insight categories with the ability to drill into each category by clicking the reddish-orange ‘View Findings’ button. Or, you can view all findings in the Explorer tab at the top. Let’s walk through how to explore these.

![Insights page in SELECT](https://cdn.sanity.io/images/wn0ylp2c/production/89f01fc5c40f1cf3a1a01bb5e1992fe066104e48-800x397.gif)

### Exploring Insights by Category

On the main Insights page, you’ll find 6 categories of insights that you can explore one at a time. For example, let’s click the “View Findings” button on the “Enable Automated Savings” card.

![View insight findings in SELECT](https://cdn.sanity.io/images/wn0ylp2c/production/2172c0b5e4aa07f1438e77c27267ed38c838d0bd-1668x708.png)

The subsequent page will show each insight. In this case, it highlights warehouses where the Automated Savings feature can be enabled. The Side Peek button will give more info.

![Insights Explorer in SELECT](https://cdn.sanity.io/images/wn0ylp2c/production/037543c893b12ce57b8f570bd4e3bdcc750599cc-1676x555.png)

Let’s walk through one more insight category. Click “High Run Frequency Workloads” insight category:

![SELECT Insights](https://cdn.sanity.io/images/wn0ylp2c/production/b0fc646a91291ca346d5b82155e3ff8b67ad66a4-1660x706.png)

On the subsequent page you’ll find each workload that is running frequently, and in some cases you’ll get a tool-tip that compares the write frequency vs the read frequency of a table.

![SELECT Insights](https://cdn.sanity.io/images/wn0ylp2c/production/be4136e699ba4f79103a6027398084b90578d429-1669x370.png)

Let’s use the side peek button to open up the side drawer. Here we can use the slider to see the savings by reducing the run frequency of the job.

![SELECT Insight: Reduce run frequency of Snowflake job to save](https://cdn.sanity.io/images/wn0ylp2c/production/36ae7a7ada9647646c8b36adc7b230c11a11d71c-2048x1372.png)

### Find Low Effort Opportunities

To find low effort opportunities, click the Explorer tab near the top of the Insights Page. On the Explorer page, click the “+” Filter button, then select Effort → is → Low.

![Find low effort Snowflake savings in SELECT](https://cdn.sanity.io/images/wn0ylp2c/production/bc5e0bd615a34c63437e737f3bf7badc5cd8351f-720x442.png)

Now you have a list of all your low effort optimizations!

![SELECT Insights: Low effort snowflake savings](https://cdn.sanity.io/images/wn0ylp2c/production/4fa0556b30d7c2f323a2de33cfcb046956ef1430-1657x799.png)

### More on the Insight Explorer

It is worth noting that we have more Insight Categories than are shown on the Insights home page. On the Explorer page, you can use “Insight is” filter to see a list of all the insight types.

![All insight (Snowflake Savings) categories in SELECT](https://cdn.sanity.io/images/wn0ylp2c/production/f93fb2aa79150c4ea731abbeb4a773e4aab15b72-850x674.png)

When you hover on an Insight Name, you’ll get a nicely formatted tooltip explaining the Insight:

![SELECT Insight explanation](https://cdn.sanity.io/images/wn0ylp2c/production/5cee4ae892071cd8b357aa31e1bd2ac76469b8d3-1680x336.png)

### Click into a Resource to Learn More

In any Insight side drawer, you can click the View Resource button to learn more.

![Drill down on insights in SELECT](https://cdn.sanity.io/images/wn0ylp2c/production/59f7259b711469d3fce59cfa182ed9ab3b39c9ea-598x269.png)

This will navigate you to the page for that specific resource. In this case it is the dbt Resources page for the Orders model. From here, I can click through all of the tabs to learn more.

![SELECT Snowlake cost savings insights drill down](https://cdn.sanity.io/images/wn0ylp2c/production/d9ffc793c723060a0b4605239d3cb69f296b15ca-800x454.gif)

### Dismiss an Insight if You Want to Ignore it

If you decide an insight isn’t applicable, click the Dismiss Insight button for the insight. You can then add a dismissal reason, i.e. “Cannot reduce run frequency of this workload due to business requirements”.

![SELECT dismiss insights](https://cdn.sanity.io/images/wn0ylp2c/production/a9e25af4cde5383893fdc100c2dfb99f98a3eb08-2048x1379.png)

If you’d like to review your Dismissed Insights, you can do so by filtering the Explorer page to “Dismissed = true” and revisit previously dismissed Insights.

![SELECT review dismissed insights](https://cdn.sanity.io/images/wn0ylp2c/production/c429aa710c95979a12acfc4e7086516357774dfb-2048x1375.png)

### Filter the Insights Explorer by Usage Group

Don’t forget that all tables in SELECT, including Insights, are filterable by Usage Group Sets. This is an easy way to get Insights that apply to your specific team. See our [guide on Usage Groups](https://select.dev/docs/reference/usage-guide/allocating-costs-with-usage-groups) to learn more.

![SELECT filter insights](https://cdn.sanity.io/images/wn0ylp2c/production/85f7405b469171906d99583f6b9510e0d68b3a12-1669x442.png)

## Method 2: Explore Top Workloads

The next step is to explore the Workloads page(s), either from the All Workloads page or from a specific Workload type. The tables will automatically be sorted by your highest cost Workloads.

For each workload, ask yourself the following questions:

1. Evaluate if you can run things less frequently. Changing an hourly job to run only during business hours saves 67%. Changing a daily job to run on weekdays only, you save 29%. Running workloads less frequently is one of the most powerful cost optimization strategies, and takes very little effort! 
2. Evaluate if you can run Workloads on a smaller warehouse size. If using dbt, consider using an Extra-Small as the default warehouse size and use a larger warehouse for particular workloads that require more resources. This is another powerful cost savings technique that takes less than a day to fine tune. Be sure to monitor cost and performance of any adjustments you make using the workloads page → cost and performance tab.

![Save money in Snowflake by running jobs less frequently](https://cdn.sanity.io/images/wn0ylp2c/production/6823507977e7446876e0ae698ae120e16c5a4266-949x787.png)

When you drill into a Workload by clicking it (click the leftmost column in the Workloads table), you can see if that workload has any specific insights.

![Workload insights in SELECT](https://cdn.sanity.io/images/wn0ylp2c/production/0cb88069a9e3228487623549b28bea6f4045d8ed-800x400.gif)

## Method 3: Use Lineage to spot additional opportunities

[YouTube video](https://youtu.be/9LhNRXRVUPg)

Using the Workloads → All Workloads page, we can find our most expensive workloads. Then we can drill into any interesting Workload by clicking on the Workload name. To analyze the lineage of that workload, click the Lineage tab.

In this example, I’ll analyze the lineage of my most expensive dbt asset, Orders.

You can expand the graph by clicking the + or “expand all” icons.

![Using SELECT's lineage page to identify Snowflake optimization opportunities](https://cdn.sanity.io/images/wn0ylp2c/production/2764d49ad9890776234e9897c146e36cf9968d4b-800x401.gif)

Hover on the node KPIs to get informative tool tips.

Click on a node to open the side drawer for more details on that node, or click the “View Resource” button to get more detail on that node. From here, you can see a chart of cost over time under cost trends, a run frequency chart, and a list of all users access that Snowflake resource of BI dashboard.

![Navigate to details from Lineage page in SELECT](https://cdn.sanity.io/images/wn0ylp2c/production/242b9aa129cdefc957c8ac09c67ee4bff4dcaad2-1721x879.png)

The KPI tile in the upper right of the Lineage page shows the total annualized cost of all of the expanded nodes in your graph. As you expand more nodes, this tile will update.

![See total cost of DAG in SELECT's lneage page](https://cdn.sanity.io/images/wn0ylp2c/production/78d9c9cc897a51c25ba53eb797baddd3702433fd-1673x846.png)