locked
Polybase for Blob Storage, to get data from Azure Data Lake Gen2 RRS feed

  • Question

  • It is difficult to find documentation if this is supported or not.

    There is documentation that says import from Azure Data Lake Storage for SQL Server 2016/17/19 is not possible. But this was before the Multi-Protocol access came up, so you might think that you could use Polybase against the Blob endpoint of ADLS?

     

    Saturday, January 11, 2020 11:17 AM

Answers

  • Hi Florian,

    I found some documentation on support for ADLS Gen 2 in comments section, here is the update on support for ADLS Gen 2 and Polybase, looks like  connection to ADLS Gen 2 may be supported  if the ADLS does not support hierarchical namespace. 

    Can you please check the comments  section in the link below:

    https://docs.microsoft.com/en-us/sql/relational-databases/polybase/polybase-configure-azure-blob-storage?view=sql-server-ver15

    Hope that helps, let me know for any further questions on this.

    Regards,

    Sriharsh

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it . Blog - srihashadari.com

    Saturday, January 11, 2020 2:21 PM