Forum Discussion

yllsuarez76's avatar
yllsuarez76
Icon for Microsoft Employee rankMicrosoft Employee
2 years ago
Solved

Fabric: SQL end point not showing external delta tables.

external tables shown on Lakehouse but not in SQL Endpoint.          
data engineering
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi yllsuarez76 ,

    Thanks for the information provided. Sorry for the inconvenience, currently the external tables created with spark code wont be visible in SQL endpoint. We can use shortcuts in Table space to make External tables visible to SQL endpoint.

     


    For more information refer this documentation: Doc1 
    Hope this helps. Please let me know if you have any further queries. Glad to help.

yllsuarez76's avatar
yllsuarez76
Icon for Microsoft Employee rankMicrosoft Employee
2 years ago

I created the tables from a noetbook as follow, both tables were create on LakeHouse successfully. However only one shows at SQL end point.

 

df.write.format("delta").saveAsTable("sales_internal")
df.write.format("delta").saveAsTable("sales_external", path="Files/raw/mslearn/sales_external")
 

LakeHouse