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
Deployment Pipelines - Remember selected stage
Every time we go into a deployment pipeline, it defaults to selecting the Development stage. I believe that it would be very rare to have a user select the Development stage. It would be helpful if d...PeterDaniels7 hours agoAdvocate IINew1View0likes0CommentsDisable auto-restore previous session's tabs in new Fabric sessions
Description: Since a recent update, starting a new Fabric session — for example by opening Fabric in a new browser tab — automatically reopens all the item tabs that were left open from a previous s...MathieuVr14 hours agoFrequent VisitorNew58Views5likes1CommentExported PDF from PowerBI to not have any indents/borders
Currently, using the "Export to PDF" option in PowerBI results in two consistently buggy results: A white border/indent is generated, increasing the size of the page from 8.5x11 to 9x11.5 Sometime...EliShalev17 hours agoNew MemberNew13Views0likes0CommentsAdding a Container for Logical Grouping of Activities in Data Pipelines
Dear Team, I would like to propose a feature enhancement for Data Pipelines in Microsoft Fabric that allows the logical grouping of activities into a container. This container would serve to: Im...lukas_karlovsky18 hours agoNew MemberPlanned877Views15likes5Comments