none
Queries across multiple Data Lake Instances

    Question

  • Is it possible to join data across multiple instances of Azure Data Lake.

    1) Across subscriptions?

    2) Within a subscription?

    3) If it is possible what are the considerations.

    Thanks much.

     

    Friday, December 1, 2017 9:59 PM

All replies

  • 1- Yes it is possible to do it across subscriptions, you can find the release noted here: https://github.com/Azure/AzureDataLake/blob/master/docs/Release_Notes/2017/2017_03_09/USQL_Release_Notes_2017_03_09.md#catalogs-can-be-shared-among-adla-accounts-even-across-different-primary-adls-accounts

    2/3- You can make queries within a subscription accross multiple Azure Data Lake accounts, this can be done through the use of HDInsight cluster  as mentioned in this tutorial . 
     
    Let me know if this helped.
    Friday, December 1, 2017 11:11 PM