PeterDaniels
Advocate III
9 months agoStatus:
New
UI for Editing Small Lakehouse Tables (Metadata & Reference)
Summary
Add a simple UI to edit small Lakehouse (Delta) tables used for metadata, configuration, and reference/lookup data. Today, even trivial edits require Spark or SQL, which makes managing these simple tables more cumbersome.
Problem
Many Fabric Lakehouse tables are:
- metadata (jobs, tasks, entities, config)
- small reference or lookup tables
These tables are small, hand-maintained, and operational, not analytical. They often need minor row-level edits, but Fabric has no UI for this.
Proposed
Provide a grid-style editor UI:
- Read-only by default, explicit edit mode
- Edit / add / remove rows (with limits)
- Validation, confirmation, and audit logging
- Role-based access
Edits commit as Delta ACID transactions.
Why
This improves operability and governance while avoiding ad-hoc notebooks and SQL
1 Comment
- PeterDaniels
Advocate III
Really, adding this for other data stores would be great as well. Could even just be a capability in SSMS.
Recent ideas
Support external tables for parquet/csv in Fabric DW
Fabric Data Warehouse allows reading Parquet and CSV files using the OPENROWSET function. However, it does not support external tables that reference Parquet or CSV files (CREATE EXTERNAL TABLE (Tran...jovanpop-msft2 hours agoMicrosoft EmployeePlanned2.9KViews38likes3CommentsFabric warehouse SQL editor: improve Ctrl-Enter
Today the Fabric warehouse SQL editor executes the full text in the editor when you press Ctrl-Enter without anything selected. It would be very convenient if Ctrl-enter only executed the single sql...stegus642 hours agoNew MemberNew17Views0likes1Comment