How to Add value to Comment Column in Databricks Catalog View for Foreign table (Azure SQL)

Leon_K — Tue, 02 Apr 2024 21:24:14 GMT

Hi.

Struggling to add description by script to the comment column within the catalog view in Databricks, particularly for foreign/external tables sourced from Azure SQL.

I have no issue doing that for delta tables.

Also for information schema columns for delta tables I see "comment" column, but not for Azure SQL .

Wondering if it's possible to add "comment" values by script for foreign table in Databricks to appear in the catalog view.

Re: How to Add value to Comment Column in Databricks Catalog View for Foreign table (Azure SQL)

Leon_K — Fri, 19 Jul 2024 19:50:00 GMT

@Retired_mod Sorry, I did read this way back but forgot to reply.
Thanks for information.

And all those steps I found as well and for "3. Programmatic Approach (For Azure SQL)" if you are adding to sql any description that way I don't think it will appear in a databricks workspace - on "comment" field.

topic How to Add value to Comment Column in Databricks Catalog View for Foreign table (Azure SQL) in Get Started Discussions

How to Add value to Comment Column in Databricks Catalog View for Foreign table (Azure SQL)

Re: How to Add value to Comment Column in Databricks Catalog View for Foreign table (Azure SQL)