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.
This solution did not work out as the get request via API showed only the tables I already could see in the fabric UI in the browser. So I have to create a ticket for microsoft support.
v-menakakota
Community Support
Community SupportHi Antongig ,
We really appreciate your efforts and letting us know the update on the issue.
Please continue using fabric community forum for your further assistance.
Thank you.