topic Re: Unable to see Schema shortcut in SQL Endpoint in the Lakehouse in Data Engineering

Unable to see Schema shortcut in SQL Endpoint in the Lakehouse

Anonymous — Tue, 10 Dec 2024 10:45:46 GMT

We have created a shortcut to a schema from a lakehouse(lh1) in one workspace(ws1) into another lakehouse (lh2) in other workspace(Ws2).

We are unable to see the shortcut schema in the new lakehouse (lh2) SQL endpoint.

Are we missing anything?

Re: Unable to see Schema shortcut in SQL Endpoint in the Lakehouse

Anonymous — Wed, 11 Dec 2024 03:15:54 GMT

Hi @Anonymous ,

I can not reproduce your problem.

I have created a normal lakehouse in a new workspace and I am unable to create a shortcut to a schema in another workspace's lakehouse, I think the reason is that it is not a delta table so it is not recognized. When I created the table in another workspace's lakehouse as a shortcut, it worked.

They all display successfully in the corresponding SQL endpoints in lakehouse.

I created a lakehouse with schema preview enabled, ran the same test and it worked fine.

I have some suggestions:

Make sure Lakehouse and SQL Endpoint are properly refreshed and synchronized, a manual refresh may be required.

Tables and shortcuts may not be visible in the SQL Endpoint if Lakehouse has schema preview enabled.

Known issue - Tables aren't visible in the SQL analytics endpoint in schema enabled lakehouse - Microsoft Fabric | Microsoft Learn

Try recreating the shortcut to see if the problem persists.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

Re: Unable to see Schema shortcut in SQL Endpoint in the Lakehouse

Anonymous — Tue, 17 Dec 2024 06:55:10 GMT

Hi @Anonymous ,

Is my follow-up just to ask if the problem has been solved?

If so, can you accept the correct answer as a solution or share your solution to help other members find it faster?

Thank you very much for your cooperation!

Best Regards,
Yang
Community Support Team