topic Lakehouse tables to do not appear in SQL endpoint in Data Science

Lakehouse tables to do not appear in SQL endpoint

spartan27244 — Fri, 02 May 2025 15:05:12 GMT

I am using PySpark in my notebook to write to a delta table in my lakehouse, however the table is NOT showing up in the SQL endpoint. I did NOT check the option for Lakehouse Schemas when the lakehouse was created. Anything I can do?

Re: Lakehouse tables to do not appear in SQL endpoint

V-yubandi-msft — Mon, 05 May 2025 06:29:32 GMT

Hi spartan27244 ,

Thank you for engaging with the Microsoft Fabric Community. Since the current Lakehouse was set up without Lakehouse Schemas enabled, any Delta tables created using PySpark aren't being registered in the SQL analytics endpoint, which is why they’re not showing up.

Creating a new Lakehouse with Lakehouse Schemas turned on. This setting ensures that tables written with PySpark are automatically registered and become visible in the SQL endpoint.

Once the new Lakehouse is ready, re-run your code to write the Delta table, and it should appear in the SQL view as expected.

If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.

Re: Lakehouse tables to do not appear in SQL endpoint

spartan27244 — Thu, 08 May 2025 12:07:16 GMT

The problem turned out to be that I was specifying a path when writing the table instead of letting it write to the default (wherever that is). When I removed the patch the tables appear in the SQL endpoint as expected. This occurs regardless of if schemas is enabled or not.