Forum Discussion

sun-sboyanapall's avatar
sun-sboyanapall
Icon for Advocate I rankAdvocate I
2 years ago
Solved

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_ful...
data engineering
lakehouse
notebook
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.

 

 

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.

  • sun-sboyanapall's avatar
    sun-sboyanapall
    Icon for Advocate I rankAdvocate I
    2 years ago

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