JohnMiner3
6 months agoNew Member
Status:
Under Review
Fabric - Warehouse + Database - Add syntax to SQL language for comments
Since the foundational format for one lake is the delta file format, why has no SQL syntax for adding comments to both Tables and Columns within tables.
With Generative AI, it more important than ever to tag tables and columns with descriptions.
Below is the syntax supported by delta files for tables.
COMMENT ON TABLE table_name IS 'your desired comment';'
Below is the syntax supported by delta files for columns.
ALTER TABLE table_name ALTER COLUMN column_name COMMENT 'your desired column comment';
Please see vendors like Snowflake (warehousing) and PostgreSQL (database) that have implemented this syntax. It is alot cleaner than the stored procedure syntax in Fabric SQL database. Below is the comment on a table.
EXEC sp_addextendedproperty
@name = N'MS_Description',
@value = N'This table contains information about library books on loan, including their ID, book ID, member ID, borrow date, due date, and return date.',
@level0type = N'SCHEMA',
@level0name = N'data_raw',
@level1type = N'TABLE',
@level1name = N'loans01';
Additionally, a comment on a column.
EXEC sp_addextendedproperty
@name = N'MS_Description',
@value = N'LoanID',
@level0type = N'SCHEMA',
@level0name = N'data_raw',
@level1type = N'TABLE',
@level1name = N'loans01',
@level2type = N'COLUMN',
@level2name = N'The primary key for the loans table.';
1 Comment
- sukkaurMicrosoft EmployeeStatus changed:NewtoUnder Review
Recent ideas
Time slicer with date picker customization
The new time slicer with date picker https://learn.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range has this limitation: The relative week options assume weeks start on Sunda...BrunoT13 minutes agoFrequent VisitorNew1View0likes0CommentsProgrammatic point-of-failure recovery for Fabric pipelines
The Fabric monitoring UI already supports Rerun → rerun from failed activity. That capability is only reachable by a human clicking in the portal. Please make point-of-failure recovery available to a...EversonElias1 hour agoRegular VisitorNew1View0likes0CommentsEnable Managed Private Endpoints Support for Microsoft Fabric Capacities Below F64
Managed Private Endpoints in Microsoft Fabric are currently supported only on F64 and higher capacities. Customers using lower capacities, such as F8, cannot establish private connectivity to Azure s...v-tsindhu2 hours agoMicrosoft EmployeeNew6Views0likes0CommentsAccessibility bug: Notebook cell text becomes invisible under Windows 11 High Contrast mode
Any text written inside a Fabric notebook is invisible when Wndows High contrast mode is enables. This applies to cell text only (not the UI). In addition, auto-complete windows are not respecting t...abigb4 hours agoNew MemberNew3Views0likes0Comments