topic Re: Backup/Export Databricks SQL Column Comments in Data Engineering

Backup/Export Databricks SQL Column Comments

804082 — Fri, 25 Aug 2023 14:53:59 GMT

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?

Re: Backup/Export Databricks SQL Column Comments

shan_chandra — Fri, 01 Sep 2023 21:16:40 GMT

@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

Re: Backup/Export Databricks SQL Column Comments

804082 — Tue, 05 Sep 2023 13:46:54 GMT

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.