Backup/Export Databricks SQL Column Comments
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-25-2023 07:53 AM
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-01-2023 02:16 PM
@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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-05-2023 06:46 AM
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.
