Forum Discussion

Rutuja1997's avatar
Rutuja1997
Frequent Visitor
1 year ago
Solved

An internal error has occurred while applying table changes to SQL.

when I made changes to the tables and resaved it with overwrite mode to the lakehouse ,I got an error saying 'Failed to load tables' in the lakehouse SQL analytics Endpoint view with error code 'Blob...
  • nilendraFabric's avatar
    1 year ago

    Hi Rutuja1997 

     

    Overwriting tables in Spark can sometime cause temporary mismatches between the Lakehouse’s Delta Lake metadata and the SQL Endpoint’s schema cache. The `BlobNotFound` error often indicates the SQL Endpoint is referencing outdated file paths

     

    Very good tutorial to solve the similar issue :

    https://m.youtube.com/watch?v=toTKGYwr278