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. 🍍🍕
... View more