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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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's avatar
yllsuarez76
Icon for Microsoft Employee rankMicrosoft Employee
2 years ago

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.