Backup/Export Databricks SQL Column Comments

[804082]

We've had users make comments on tables/columns throughout Databricks SQL using the Data Explorer UI. I'm looking for a way to backup these comments, but when I run DESCRIBE TABLE, the comment column is always null despite being non-null in Data Explorer. Is there another approach that I can use that will pull comments for all tables and columns?

[shan_chandra]

@804082  - Markdown does not render when returned by DESCRIBE statements. we can view them on the Data Explorer UI.

Reference:   https://docs.databricks.com/en/data/markdown-data-comments.html#document-data-with-markdown-comments

[804082]

Appreciate the response. When I add a comment via "ALTER TABLE ... CHANGE COLUMN ... COMMENT ...", the comment is still shown in the Data Explorer UI. I suppose it's a one-way thing where comments on the table are visible in the Data Explorer UI but Data Explorer UI comments are not actually in the table.