Resilience Check Failed — Table Change State Unknown After Shortcut Sync in SQL Analytics Endpoints

Hi aniruddhabh ,

I have used the below to resolve the issue

--Use a Notebook to Force Metadata Registration. Even though the shortcut is created, the table may not be auto-registered in Spark/SQL. You can manually register it in Spark

-- Refresh Metadata in Spark Engine, Not Just SQL Endpoint. Sometimes the SQL Endpoint refresh UI doesn’t push updates correctly from OneLake. Run this in a Spark notebook

-- Check for Partial Commits or Delta Corruption. 

Even if files exist, metadata sync may fail if:

• There’s a partial _delta_log commit (e.g., _commit.json.tmp)

• There’s a missing _delta_log/00000.json

If this post helps, then please appreciate giving a Kudos or accepting as a Solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!