K_Anudeep
Databricks Employee
Databricks Employee

Hello @Malthe ,

Currently, there is no supported way to repair broken clustering metadata in Delta materialised views if you remove the clustering key from the definition, other than dropping and recreating the materialised view. Additionally, a full refresh cannot resolve the underlying Delta clustering metadata inconsistency when the clustering key is removed or changed, as fullRefresh is meant for recomputing the data, not rewriting the MV’s underlying Delta table properties (such as clustering keys).

I have checked this internally, and it appears to be a known issue that will be resolved and rolled out by the end of January 2026.

 

Anudeep

View solution in original post