cancel
Showing results for 
Search instead for 
Did you mean: 
Data Governance
Join discussions on data governance practices, compliance, and security within the Databricks Community. Exchange strategies and insights to ensure data integrity and regulatory compliance.
cancel
Showing results for 
Search instead for 
Did you mean: 

Is there a way to import table , column descriptions into unity catalog?

prasad_vaze
New Contributor III

I have a spreadheet containing table & column descriptions (comments) 

Is there a way to upload this against the schema in unity catalog? 

Basically instead of running  'Alter table <> alter column <>  comment "description"  '  command for every column, is there an easy way to mass apply column comments in unity catalog schema? 

1 REPLY 1

sourav69201
Databricks Employee
Databricks Employee

One of the ways to do it is to create a delta table using the Spreadsheet and loop through the delta table. Then, use the field value and create a dynamically alter query to update the description.