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

[Leon_K]

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. 

[Leon_K]

@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.