Polybase and Azure Synapse Analytics

Sun Shine 296 Reputation points
2021-05-16T23:04:19.267+00:00

Hello:

To my basic understanding, I can use Polybase for Data Virtualization.

Instead of importing\ELT\ingesting On-Prem data into Azure Synapse Analytics (Dedicated SQL Pool), I want to use Polybase to do Data Virtualization, so that I can directly query on-prem SQL Server Databases.

I want to learn & understand, how to configure\create Polybase for Data Virtualization on Azure, so that I can query my on-prem databases and from Dedicated SQL Pool.

Do I have to create a new Azure SQL Instance to configure\create for Polybase for Data Virtualization ???

Any help or link is greatly appreciated.

Thanking in advance.

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,111 questions
0 comments No comments
{count} votes

Accepted answer
  1. PRADEEPCHEEKATLA-MSFT 73,646 Reputation points Microsoft Employee
    2021-05-17T07:43:57.39+00:00

    Hello @Sun Shine ,

    Thanks for the question and using Microsoft Q&A platform.

    The PolyBase feature provides connectivity via Azure Blob Storage and Azure Data Lake Store.

    This table lists the key features for PolyBase and the products in which they're available.

    97091-image.png

    If you are exporting from SQL Server, you can use bcp command-line tool to export the data into delimited text files.

    For more details, refer the below articles:

    Design a PolyBase data loading strategy for dedicated SQL pool in Azure Synapse Analytics

    Introducing data virtualization with PolyBase.

    Hope this helps. Do let us know if you any further queries.

    ------------

    Please don’t forget to Accept Answer and Up-Vote wherever the information provided helps you, this can be beneficial to other community members.


0 additional answers

Sort by: Most helpful