Forum Discussion

yllsuarez76's avatar
yllsuarez76
Microsoft 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.

7 Replies

  • 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
      Microsoft 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.

  • yllsuarez76's avatar
    yllsuarez76
    Microsoft 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

     

     

     

     

     

     

     

     

     

     

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    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 ,
      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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

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

  • rceslinski's avatar
    rceslinski
    Frequent Visitor
    2 years ago

    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!