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
Community Support
1 year ago

Hi  Antongig  ,
Thanks for reaching out to the Microsoft fabric community forum.
 

You could try using the Lakehouse REST API to list all the tables in your Lakehouse sometimes it shows hidden or stuck entries that don’t appear with ShowTables.

Look for the_delta_log._commits entry using the GET tables API call. If it shows up there, it means the metadata is still registered in the backend.

Here’s the link to the API documentation which may help you:
Lakehouse management API - Microsoft Fabric | Microsoft Learn

 

If I misunderstand your needs or you still have problems on it, please feel free to let us know.   

Best Regards,  
Community Support Team 

v-menakakota's avatar
v-menakakota
Community Support
1 year ago

Hi Antongig ,

I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.

Thank you.