cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Data Engineering
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Columns tab in Data Explorer doesn't reflect schema changes to table

rahulmadnawat
New Contributor II

Hey team, we've noticed that schema changes to a table after creation aren't reflected in the "Columns" tab in the Data Explorer. For example, we added a column called signal_description to a table but its addition isn't reflected in the UI. Is this a known issue? If we run DESCRIBE TABLE on the table the column appears though.

rahulmadnawat_0-1689893241839.png

 

1 ACCEPTED SOLUTION

Accepted Solutions

Tharun-Kumar
Honored Contributor II
Honored Contributor II

@rahulmadnawat 

Is this a Unity Catalog enabled table?

If so, could try running - REPAIR [unity.table] SYNC METADATA

This should refresh the schema on the UC metadata.

View solution in original post

3 REPLIES 3

Tharun-Kumar
Honored Contributor II
Honored Contributor II

@rahulmadnawat 

Is this a Unity Catalog enabled table?

If so, could try running - REPAIR [unity.table] SYNC METADATA

This should refresh the schema on the UC metadata.

Yup that worked, thanks @Tharun-Kumar!

claudius_hini
New Contributor II

@Tharun-Kumar 
Is this behavior the default behavior in case a schema change happens on a table registered in unity catalog?
In that case I would have to run the repair command regularly in order to ensure that the schema displayed is actually the one of the delta table?

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.