How to Add value to Comment Column in Databricks Catalog View for Foreign table (Azure SQL)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-02-2024 02:24 PM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-19-2024 12:50 PM
@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.
