Forum Discussion
sun-sboyanapall
Advocate I
Advocate ILakehouse 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_ful...
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).
AndyDDC
Most Valuable Professional
Most Valuable Professionalhi sun-sboyanapall @can you try writing using:
df.write.mode("overwrite").format("delta").save("Tables/Salesforce_lead_full")
This was my issue - I have a custom function which writes dataframes to delta tables, and it was working, showing up as a table in my lakehouse and as a file in my lakehouse - what it wasn't doing was actually creating a table in my SQL endpoint "warehouse", writing it like this ,made it visible in my lakehouse sql endpoint schema.
