Delta external table metadata does not match the Catalog explorer view

Run the MSCK REPAIR command.

Written by Rajeev kannan Thangaiah

Last published at: January 14th, 2025

Problem

You notice the metadata for a Delta external table is not synchronizing with the Catalog explorer view. Certain columns are visible in the table but not in the Catalog explorer view. 

 

Cause

The external table was updated outside of Databricks. 

 

Solution

Run the following command, which reads from the Delta log of the table and updates the metadata in the Unity Catalog service. 

MSCK REPAIR TABLE <table_name> SYNC METADATA