Analyze overscheduled and unused pipelines

A great way to save money in Snowflake is by reducing pipeline waste. Common opportunities include removing unused pipelines that no longer have downstream consumers, or reducing the schedule of pipelines that run more often than the data is actually consumed.

On any workload page, you will see our new Pipeline Analysis tab, which helps you understand how a workload is being used downstream.

Pipeline Analysis classifies workloads into a few categories:

Unused pipeline

The workload writes tables, but no downstream BI, analytics, or user-facing (non-ETL) workloads are reading these tables, either directly or further downstream. This may indicate the pipeline is no longer needed.

High run frequency pipeline

The workload is part of a pipeline running much more frequently than its downstream non-ETL readers. This may indicate the schedule can be reduced to lower compute costs.

Healthy pipeline

Downstream consumers are running at a similar or higher frequency than the pipeline itself, suggesting the schedule is appropriately aligned with usage.

Other Things We Shipped

• 🪄 Improved performance of Warehouses page, by only making network calls to fetch Performance column data necessary
• 🐛 Fixed issue with using Usage Groups as a filter on Home page
• 🐛 Fixed issue with Contracts page pulling in persisted inline filters from other pages, breaking Contracts
• 🐛 Fixed issue with automated Slack messages not being sent due to being over Slack's 3000 character block limit