Problem When developing or operating Warehouseโbacked models, we often need small, surgical data fixes - e.g., correcting an erroneous valid_to_dt in an SCD2 dimension or updating a junkโdimension attribute. In SQL Server/SSMS, the โEdit TopโฏN Rowsโ grid makes this fast and safe. Fabric Warehouses currently lack a GUI row editor, pushing teams to external tools (e.g., DataGrip) or adโhoc DML scripts. This creates friction, slows incident resolution, and fragments toolingโeven though Warehouses already support full DML via TโSQL. Proposal Provide a firstโclass โEdit TopโฏN Rowsโ experience for Warehouse tables: Fabric Portal: grid editor with inline add/edit/delete, filter, and commit/rollback. SSMS / VS Code: enable the same grid or a lightweight editor with โgenerate DMLโ preview. Respect Warehouse permissions/RLS; optionally log changes via SQL Audit Logs and take a TimeโTravel snapshot for quick rollback. Why this matters Speeds data quality hotfixes, removes the need for competitorsโ tools, and lets us fully standardize on VS Code + SSMS + Fabric while retaining governance and safety.
... View more