Environment Assessment

Comprehensive analysis of your Snowflake environment

Monthly Spend

$149.5K

Savings Potential

$163K

Issues Found

24

Warehouses

4

Storage

13.1 TB

Warehouse Analysis
Performance and cost metrics for each warehouse
WarehouseSizeMonthly CostUtilizationQueriesRecommendationSavings
ANALYTICS_WHX-Large$45,000
23%
145K/moDownsize to Large$22,500
ETL_WH2X-Large$89,000
67%
320K/moEnable auto-suspend$15,000
REPORTING_WHMedium$12,000
89%
890K/moOptimal-
DEV_WHSmall$3,500
12%
23K/moConsider X-Small$1,500
Top Performance Issues
Queries requiring immediate attention
SELECT * FROM large_table WHERE...High
45minAdd clustering key
JOIN across 8 tables without filtersHigh
32minAdd predicates
Full table scan on 2TB tableMedium
28minUse partition pruning
Cartesian product detectedCritical
15minFix join condition