Forum Discussion
Solved
Cannot Remove Invalid Table "_delta_log._commits" — SQL Sync Blocked
Hello, I'm experiencing a persistent issue in Microsoft Fabric Lakehouse. Lakehouse: Silver_Lakehouse Issue: SQL Sync fails due to a phantom table _delta_log._commits. Error Message: Delta ta...
Hi Antongig
Somewhere you deleted the transaction log file or data is corrupted due to _delta_log. For that, you need to delete the whole table ( single table ) and recreate the table using Python or scala commands which ever you think is relevant.
Also, Which database are you using as a source. I mean to say Azure SQL. SQL Server...etc.
BhaveshPatel
Super User
Super User