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
Ability 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...SaiValipireddy3 minutes agoRegular VisitorNew3KViews26likes3CommentsFeature Request: Option to Disable the Built-in “Select All” for Multi-Value Parameters
When customers build paginated reports using Power BI Report Builder, enabling a multi-value parameter automatically displays the built-in “Select All” option at the top of the available values list....ffhfjjhvhjvhj4 minutes agoMicrosoft EmployeeNew0Views3likes0CommentsRestore "no-reply" option for Power BI Subscriptions
Please add a setting in the Power BI Subscription pane to choose the sender identity. With the recent update the platform forces emails to route through the subscription owner's personal Exchange On...LenaFid3 hours agoRegular VisitorNew593Views87likes22CommentsAbility to Decrypt PII info based on Logged-in User
Many clients has Data Encryoted using their application logic and that data is imported into OneLake. Clients are looking for ability to decrypt the data only fly based on logged-in user (RLS/CLS). ...nsidhu3 hours agoMicrosoft EmployeeNew3Views0likes0Comments