Forum Discussion

Antongig's avatar
Antongig
Frequent Visitor
1 year ago
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...
data warehouse
  • BhaveshPatel's avatar
    BhaveshPatel
    1 year ago

    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. 

v-menakakota's avatar
v-menakakota
Icon for Community Support rankCommunity Support
1 year ago

Hi Antongig ,

We’d like to follow up on your support ticket. Has the issue been successfully addressed?

If a solution was provided, we’d truly appreciate it if you could share your experience or any relevant details, your input could be valuable to other community members.

 

Thanks again for being an active part of the Microsoft Fabric Community!