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