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...
one lake
  • nilendraFabric's avatar
    nilendraFabric
    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

     

     

nilendraFabric's avatar
nilendraFabric
Icon for Super User rankSuper User
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