SQL Governance, Performance & Cost Control

Riverton Media • 14TB Snowflake • 3.2M queries/month

Target: Slot P95 ≤65%, Dup Queries ≤10%
Governed Layer Active
Governed Query Share
63%
+8% MTD
Full-Table Scan Rate
11%
-4% vs goal
Warehouse Slot P95
71%
-7% WoW
Duplicate Query Hash
16%
-6% MTD
Cache Hit Rate
54%
+3% WoW
Cost per Successful Run
$0.42
-$0.09 MTD

Slot Utilization P95 – 30 Days

Policy Violations by Type – Last 7 Days

Top 10 Expensive Query Hashes – MTD

Query Hash Domain Executions Avg Runtime Data Scanned Total Cost Status
a8f3d2e1... Marketing 18,247 12.4s 2.8TB $9,421 Full Scan
c4b7e9f2... Finance 4,132 8.7s 1.2TB $3,284 Governed
e9a1d3c8... Sales 6,891 6.2s 0.9TB $2,947 Governed
f2d8e4b1... Product 2,456 18.9s 1.4TB $2,631 Cross-Region
b3c9a7e5... Analytics 3,782 7.1s 0.7TB $2,184 Governed
d7e2f8a4... Marketing 5,217 5.3s 0.6TB $1,923 Governed
a1f4c9e7... Finance 1,894 11.2s 0.8TB $1,672 PII Access
e8b3d1f9... Sales 4,651 4.8s 0.5TB $1,541 Governed

Query Runtime Distribution – Last 7 Days

Cache Hit Rate Trend – 30 Days

Cost by Domain – MTD ($38.2K Total)

Marketing
$14.2K
37.2%
Finance
$9.8K
25.7%
Sales
$7.1K
18.6%
Product
$4.3K
11.3%
Analytics
$2.8K
7.2%
Week 6 Incident: Marketing campaign duplicated query hash 18K times → $9.4K spike. Semantic layer mandate cut full scans from 11% → 7%.
Autotune Recommendation Acceptance
72%