Forum Discussion

vivek_goli's avatar
vivek_goli
Regular Visitor
1 year ago
Solved

Exploring data in Fabric Data Warehouse and Lakehouse in Azure Data Explorer

I want to explore and run queries on data present in Fabric Data Warehouse or Lakehouse in Azure Data Explorer without actually ingesting the data into ADX. Is there any way to use Fabric tables as external tables in Azure Data Explorer?

data engineering
lakehouse
  • v-menakakota's avatar
    v-menakakota
    1 year ago

    Hi vivek_goli ,

    We are following up once again regarding your query. Could you please confirm if the issue has been resolved through the support ticket with Microsoft?

    If the issue has been resolved, we kindly request you to share the resolution or key insights here to help others in the community. If we don’t hear back, we’ll go ahead and close this thread.

    Should you need further assistance in the future, we encourage you to reach out via the Microsoft Fabric Community Forum and create a new thread. We’ll be happy to help.

     

    Thank you for your understanding and participation.

7 Replies

  • v-menakakota's avatar
    v-menakakota
    Icon for Community Support rankCommunity Support
    1 year ago

    Hi  vivek_goli  ,
    Thanks for reaching out to the Microsoft fabric community forum. 

    If your Lakehouse data in OneLake is in Delta format, you might be able to query it from Azure Data Explorer (ADX) using the external_table() function, which is currently in preview. This lets you read the data without fully importing it into ADX.
    Currently, Azure Data Explorer (ADX) doesn't support directly querying tables from Fabric Data Warehouse or Lakehouse as external tables unless the data is ingested or connected through supported sources.
    Please go through the Documentation link:
    Create database shortcut for Azure Data Explorer database - Microsoft Fabric | Microsoft Learn


    If this post was helpful, please give us Kudos and consider marking Accept as solution to assist other members in finding it more easily.


    Best Regards, 
    Menaka.
    Community Support Team

     

     

     

    • vivek_goli's avatar
      vivek_goli
      Regular Visitor
      1 year ago

      The link you have provided seems to provide the reverse of what I have asked. Correct me if I am wrong and explain the process please

      • v-menakakota's avatar
        v-menakakota
        Icon for Community Support rankCommunity Support
        1 year ago

        Hi vivek_goli ,

        Really sorry for the previous documentation. Currently, Azure Data Explorer (ADX) doesn't support directly querying tables from Fabric Data Warehouse or Lakehouse as external tables unless the data is ingested or connected through supported sources.
        If your Lakehouse data in OneLake is in Delta format, you might be able to query it from Azure Data Explorer (ADX) using the external_table() function, which is currently in preview. Which may take few days.

        Thanks for reaching out to the Microsoft fabric community forum. 
        Best Regards, 
        Menaka.
        Community Support Team