Dashboard

Overview of your Snowflake optimization opportunities

Annual Spend

$1.8M

Transformation Compute

Savings Identified

$1.04M+58%

Across all optimizations

Optimization Score

34/100

Room for improvement

Time to ROI

3.2 months

At current implementation pace

Savings Breakdown

Click on any bar to explore that optimization category

Total Identified Savings$1.04M

Quick Actions

Recent Activity

Identified 23 zombie clustering keys

2 hours ago

Converted dim_customer to Dynamic Table

Yesterday

Warehouse TRANSFORM_WH downsized to LARGE

2 days ago

Cost spike detected on DBT_PROD_WH

3 days ago

Enabled auto-suspend on 12 warehouses

4 days ago

Optimization Levers

In Progress

Dynamic Tables

40-60% savings potential

156 candidates

In Progress

Incremental dbt

30-50% savings potential

89 candidates

Not Started

Streams + Tasks

20-30% savings potential

34 candidates

Not Started

Iceberg Tables

50-70% savings potential

12 candidates

Not Started

Hybrid Tables

Variable savings potential

8 candidates

Complete

Warehouse Tuning

15-25% savings potential

24 candidates

Not Started

Serverless Tasks

10-20% savings potential

45 candidates

Implementation Roadmap

Quick Wins2-4 weeks

Architecture6-8 weeks

Lakehouse + AI8-12 weeks

Resize TRANSFORM_WH to LARGE
Enable auto-suspend on all warehouses
Convert top 5 dbt models to incremental
Remove zombie clustering keys
Optimize top 10 expensive queries