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

rahulmadnawat
New Contributor II

‎07-20-2023 03:48 PM

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

 

0 Kudos

Tharun-Kumar
Databricks Employee
Databricks Employee

‎07-20-2023 09:52 PM

@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

rahulmadnawat
New Contributor II
In response to Tharun-Kumar

‎07-20-2023 10:07 PM

Yup that worked, thanks @Tharun-Kumar!

0 Kudos

claudius_hini
New Contributor II

‎01-12-2024 01:26 AM

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

0 Kudos