JohnMiner3
8 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
- sukkaur
Microsoft Employee
Status changed:NewtoUnder Review
Recent ideas
Embedded Power BI: allow 12/24-hour clock setting independent of formatLocale
Problem In Power BI embedded reports (app-owns-data, JavaScript SDK), localeSettings.formatLocale is the only way to influence date and time display. The hour cycle (12 or 24 hour) is tied to th...VijaySama5881 hour agoNew MemberNew3Views0likes0CommentsAdd Initial Horizontal Scroll Position to Matrix and Table Visuals
Please add an option to Power BI Matrix and Table visuals that allows report developers to configure the initial horizontal scroll position when the visual loads. Suggested setting: Format visual >...Panteras011 hour agoFrequent VisitorNew2Views0likes0CommentsFabric Mirroring (and all artifacts) - Reassign owner
Probelm: I have users who have created Mirroring from Azure SQL DB's (although this problem exists with all mirroring) and if they dont log into fabric often the mirroring breaks. While best prat...Jreed_74741 hour agoNew MemberNew116Views1like1CommentPowerBI Forced Refresh after Report Deployments
Currently, when you make an update to a PowerBI report and deploy (click update app), it doesn't force a refresh for your end users. Thus, they end up getting error messages on their reports (dependi...kaitlyn_workman4 hours agoRegular VisitorNew1View0likes0CommentsAbility for Admins to be able to delete Cloud Connections. Currently only connection owner can.
Description: Currently, only the connection owner can delete a Cloud Connection in Fabric / Power BI. Even tenant admins or Fabric capacity admins do not have permission to remove, reassign, or take...SaiValipireddy4 hours agoRegular VisitorNew3KViews26likes3Comments