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.
on:
Add a Git-tracked “resources” folder to Lakehouses
on:
Add native Dev/Test/UAT/Prod semantic model compar...
on:
Computed Columns in Fabric Data Warehouse
LiLiu_Fabric
on:
Deployment Pipeline Run in Fabric monitor