Waste Reduction

Identify and eliminate wasted spend across your data infrastructure — from orphan tables and unused pipelines to over-scheduled refreshes and idle BI licenses.

Seemore continuously analyzes your Snowflake environment to surface concrete savings opportunities across storage, compute, and licensing. Each insight includes estimated annual savings so you can prioritize high-impact actions.

---

Orphan Tables

Tables and views with no pipeline connections and zero query activity over the analysis window. Dropping them reclaims storage and reduces clutter.

Orphan Tables

Unused Data Flows

Tables that are actively written to by pipelines but never read. The upstream pipeline spend is pure waste.

Unused Data Flows

Frequency Optimization

Tables whose write frequency far exceeds their read frequency. Reducing refresh cadence saves compute without affecting consumers.

Frequency Optimization

Inactive Users

BI platform users (Tableau, PowerBI) who have not logged in within a configurable threshold. Reclaiming their licenses reduces subscription costs.

Inactive Users

Compute Idle Optimization

Warehouses kept alive by high-frequency queries that prevent auto-suspend. Reducing query frequency or adjusting auto-suspend settings reclaims idle compute spend.

Compute Idle Optimization

---

Exclude Users from Usage

Service accounts, ETL bots, and monitoring tools can generate significant query activity that inflates usage metrics. The Exclude Users from Usage setting lets you filter these users out of usage calculations so insights reflect real human consumption patterns.

How to Configure

1. Navigate to Waste Reduction → Insights Configuration (top-right button).

2. Select the Snowflake integration you want to configure.

3. Check the users you want to exclude from usage calculations.

4. Click Save.

Walkthrough: excluding users from usage calculations

Which Insights Are Affected

Insight	Affected?	Details
Orphan Tables	Yes	Excluded users' queries are ignored when determining whether a table has usage.
Unused Data Flows	Yes	Excluded users' reads are ignored, so tables read only by bots still appear as unused.
Frequency Optimization	Yes	The Snowflake queries that detect write-heavy / read-light patterns filter out excluded users.
Inactive Users	No	This insight queries BI platform login activity, not Snowflake usage.
Compute Idle Optimization	No	This insight evaluates warehouse-level uptime patterns; all query activity (including service accounts) is relevant.

Changes take effect the next time insights are recalculated (typically within 24 hours).