Fabric: SQL end point not showing external delta tables.

[yllsuarez76]

external tables shown on Lakehouse but not in SQL Endpoint.

[rceslinski]

Hi. Is there an update to this issue?
I'm trying to load external delta tables created with a notebook but the tables still don't show up on the SQL Enpoint.

Thanks!

[v-nikhilan-msft · Accepted solution]

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.

[v-nikhilan-msft]

Hi @yllsuarez76 ,
We haven’t heard from you on the last response and was just checking back to see if your issue has been resolved. Please let us know if you have any further issues.

[v-nikhilan-msft]

Hi @yllsuarez76 ,
Glad that your query got resolved. Please continue using Fabric Community for any help regarding your queries.

[yllsuarez76]

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

[v-nikhilan-msft]

Hi @yllsuarez76 ,
Thanks for using Fabric Community.
I have tried to repro the scenario at my end. I have used Copy data activity in my pipeline to copy a table named salesexternal from Azure Table Storage to Fabric Lakehouse. After successfully running the pipeline I am able to find the table in my lakehouse as well as SQL end point. I have attached the screenshots for your reference.

1) Before ingesting the table:

                                

2) Ingesting the external table present in Azure Table Storage into Fabric Lakehouse:

3) Lakehouse and SQL endpoint after ingesting the external table:

                                                           
Hence try ingesting the external tables again and let me know if the issue persists. Glad to help.

[yllsuarez76]

Thanks for taking the time to troubleshoot.

Sounds to me that the way you are ingesting the table into fabric the new table is created as a Managed table.