There is currently no reliable way to view the size of a data warehouse in Microsoft Fabric using T-SQL or the Fabric Explorer. This makes it difficult to manage storage, troubleshoot performance issues, and understand data usage.
Recommended improvements:
Fix existing DMVs so they return accurate storage usage and metadata for Fabric Data Warehouses.
Update the Fabric Explorer Table Properties UI (specifically the Properties tab) to show:
Current Size – the size of active data (such as optimized Delta files)
Total Size – the size of all files, including older versions and unoptimized data
V-Order Status – to provide insight into data layout optimization
Last Compaction Timestamp
Per-file Metrics – such as file sizes, modification times, and row counts
Enhance the Fabric Explorer column list to indicate whether a column has a primary key, foreign key, or unique index defined.
These changes would significantly improve visibility into storage and performance, making it easier to manage and optimize Fabric Data Warehouses.
Note: While some of this information can be obtained via OneLake Explorer or a Spark notebook, the experience is currently cumbersome and not user-friendly. 🍍🍕
on:
User Friendly "Load" Window (Desktop/Refresh Data)
TwinkleCyril
on:
Fabric warehouse temp table enhanced support
on:
Add Default Value Options for Date Range Picker in...