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

Join 100K+ Data Experts: Register Now & Grow with Us!

Excited to expand your horizons with us? Click here to Register and begin your journey to success!

Already a member? Login and join your local regional user group! If there isn’t one near you, fill out this form and we’ll create one for you to join!