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
Data Pipelines - Run only selected activities
For debugging and testing pipeline activities during development, allow us to select one or multiple activities and run only the selected pipeline activities. For example, I'm working on editing ...frithjof_v4 hours agoCommunity ChampionNew611Views11likes2CommentsSemantic model connection bindings should be in source control (Git)
Semantic model data source connection bindings should be source controlled. A semantic model can contain multiple data source references, each of which can be mapped to a separate Fabric data connec...frithjof_v11 hours agoCommunity ChampionNew16Views1like0CommentsBulk changing column names in Visualizations Pane
We often use raw/api column names or measures with a set nomenclature to be consistent and to keep track of them but we do not want to display these names in the visuals. Currently we have to change ...vishal14019715 hours agoFrequent VisitorNew6Views0likes0Comments