cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
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
Databricks Employee
Databricks Employee

@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
Databricks Employee
Databricks Employee

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

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you wonโ€™t want to miss the chance to attend and share knowledge.

If there isnโ€™t a group near you, start one and help create a community that brings people together.

Request a New Group