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

     

     

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Rutuja1997,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution so that other community members can find it easily.


Thank you.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Rutuja1997,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

 

Thank you.