cancel
Showing results for 
Search instead for 
Did you mean: 
Community Discussions
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Leon_K
New Contributor

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. 

1 REPLY 1

Kaniz
Community Manager
Community Manager

Hi @Leon_K, Adding comments to columns within the catalog view in Databricks can be quite useful for documentation and understanding your data. While it’s straightforward for Delta tables, handling foreign/external tables sourced from Azure SQL requires a slightly different approach.

Here are some steps you can follow to add comments to columns for foreign tables in Databricks:

  1. Using AI-Generated Comments (Recommended):

  2. Using Markdown Comments (Manual Approach):

  3. Programmatic Approach (For Azure SQL):

  4. REST API (Advanced):

Remember that documenting your data with meaningful comments enhances collaboration and understanding, so choose the method that best suits your workflow.

Happy cataloging! 📊🗂

 
Welcome to Databricks Community: Lets learn, network and celebrate together

Join our fast-growing data practitioner and expert community of 80K+ members, ready to discover, help and collaborate together while making meaningful connections. 

Click here to register and join today! 

Engage in exciting technical discussions, join a group with your peers and meet our Featured Members.