Logo

Data Management

Data Warehouse

AI Generated Summary

Storage is at 68.4TB, growing 4% month over month. Query performance is healthy at 2.4ms average, though the customer_events table would benefit from repartitioning. Monthly warehouse cost is trending 6% above budget.

Generated from 142 active queries across 247 AI models

Storage Used

68.4TB

Avg Query Time

2.4ms

Active Queries

142

Monthly Cost

$18.4K

Storage Utilization

By schema · treemap

6 schemas · 68.4TB total View data sources

Storage Growth Trend

Last 6 months

+4% month over month

Query Performance Dashboard

Query volume vs. avg latency · last 7 days

142 active queries · 2.4ms avg latency View query logs

Capacity Forecast

Projected storage · next 6 months

Projected 87TB by January View system performance

Resource Utilization

Compute credit consumption

64% of allocated compute credits

Table Statistics

customer_events18.2TB
transactions14.6TB
model_predictions12.8TB
product_catalog9.4TB
support_tickets8.1TB
misc5.3TB
audit_logs3.9TB
feature_store2.6TB
8 tables tracked View all tables

Partition Management

customer_events would benefit from monthly repartitioning — currently scanning 3.2x more data than needed for recent queries.
transactions is partitioned by day and performing within target — no action needed.
model_predictions partition pruning is scanning 1.4x expected volume — review recommended next cycle.
product_catalog is partitioned by category and performing within target — no action needed.
support_tickets partition skew detected across regions — low priority, monitor next quarter.
1 table needs repartitioning

Backup & Recovery

Last backup completed successfully

6 hours ago · retention 30 days

Backup scheduleNightly at 02:00 UTC
Storage locationCold storage, region us-east-1
Retention policy30 days rolling
Last restore testPassed · 12 days ago
Next backup in 18 hours

AI Storage Recommendations

Archive raw event logs older than 12 months to cold storage — estimated savings of $3.2K/month.
Deduplicate support_tickets attachments — estimated savings of $0.8K/month.
Downsize the misc schema retention window from 90 to 45 days — estimated savings of $0.5K/month.
$4.5K/month in potential savings

Query History

SELECT revenue rollup · 1.2s2m ago
Sarah Chen · forecast accuracy join · 2.6s14m ago
Marcus Lee · customer_events scan · 3.1s28m ago
Priya Patel · model_predictions aggregate · 0.9s41m ago
142 queries in the last hour View all logs

Warehouse Audit Logs

Alex Diaz granted read access to Analytics teamYesterday
Dana Ruiz updated retention policy on support_tickets2 days ago
Jordan Kim revoked write access for the ETL service account3 days ago
Priya Patel added Marcus Lee to the model_predictions schema owners4 days ago
18 access changes this month Manage permissions

Warehouse Activity Timeline

Nightly backup completed successfully

6 hours ago

customer_events flagged for repartitioning by AI recommendation

9 hours ago

Storage crossed 68TB threshold, triggering capacity alert

Yesterday

Alex Diaz granted read access to Analytics team

Yesterday

4 events in the last 24 hours View full history