Lakehouse sql error

Hi JaviGolden, 

Thank you for reaching out.

This error is typically caused by an internal reference issue within the SQL analytics endpoint  often linked to object metadata (e.g. missing or corrupted table/view references). Based on the nature of the error, this is very likely a service-side issue. We recommend waiting a short while and retrying the query, as such issues are often transient.

If the issue still persists, please try the following steps in addition to those suggested by suparnababu8.

1. Run a metadata query to validate object availability:

   SELECT * FROM INFORMATION_SCHEMA.TABLES;

   If this query fails, it may indicate a broader metadata or synchronization issue.

2. If there were recent deletions or renames of tables/views, reverting them (if possible) may help.

3. If available, try running a simple query in another Lakehouse to isolate whether this issue is specific.

If the issue continues, please consider raising a support ticket using the following link: Microsoft Fabric Support and Status | Microsoft Fabric

Please reach out for further assistance.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and a kudos would be appreciated.

Best regards,

Vinay