Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply

Lakehouse tables not showing up in SQL Endpoint

Hey, I have taken 60day trail for the fabric, 

 

created the table using spark notebook here is the code I have used. 

df.write.mode("overwrite").format("delta").saveAsTable("Salesforce_lead_full")

it shows up in the lakehouse

sunsboyanapall_0-1721968022901.png

but refuses to show up in the sql end point or in the model so that i can use this  dataset in powerbi to make something out of it. 

sunsboyanapall_1-1721968109026.png


other interesting thing is when i click on properties of the table I see blank value in the Format field

sunsboyanapall_2-1721968163362.png

and i can see the table files in the one lake file explorer. waited for 2 days now and its been killing me. we are doing a POC of fabric so far its been super buggy. 

sunsboyanapall_3-1721968248897.png

 

please help

 

1 ACCEPTED SOLUTION
frithjof_v
Community Champion
Community Champion

@sun-sboyanapall 

 

If you created your Lakehouse with the schemas (preview) enabled, then the SQL Analytics Endpoint won't work. Please ref. these docs: Lakehouse schemas (Preview) - Microsoft Fabric | Microsoft Learn

 

Please try to create your Lakehouse without the schemas (keep that option unchecked).

frithjof_v_0-1721983319572.png

 

View solution in original post

5 REPLIES 5
frithjof_v
Community Champion
Community Champion

@sun-sboyanapall 

 

If you created your Lakehouse with the schemas (preview) enabled, then the SQL Analytics Endpoint won't work. Please ref. these docs: Lakehouse schemas (Preview) - Microsoft Fabric | Microsoft Learn

 

Please try to create your Lakehouse without the schemas (keep that option unchecked).

frithjof_v_0-1721983319572.png

 

Thanks a ton, that worked. I have been banging my head for 2 days now. 

Anonymous
Not applicable

Hi @sun-sboyanapall ,

Thanks for @AndyDDC 's prompt reply, you can try his suggestion first.

I have some suggestions for your problem as well. The issue you are experiencing could be due to a number of reasons, the SQL Analytics Endpoint cache may not be updated in a timely manner. Try refreshing or reconnecting to see the newly added tables. And data synchronisation may take some time. Wait for a few minutes and check again.

 

vyifanwmsft_0-1721979404900.png

 

If the above methods still didn't help you solve the problem, you can consider clearing the cache and re-adding the new table, then refresh it to see if the new table is loaded in SQL Analytics Endpoint.

 

Best Regards,

Ada Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

I have actually tried all of this from other posts but it was that checkmark that was the issue in my case.

AndyDDC
Most Valuable Professional
Most Valuable Professional

hi @sun-sboyanapall @can you try writing using:


df.write.mode("overwrite").format("delta").save("Tables/Salesforce_lead_full")

 

Helpful resources

Announcements
Oct Fabric Update Carousel

Fabric Monthly Update - October 2024

Check out the October 2024 Fabric update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.