How to export a table from azure synapse dedicated DB pool

Question

How to export a table from azure synapse dedicated DB pool

Answer 1

Hi @Naresh
Thanks for the question and using MS Q&A platform.

According to this documentation: Best practices for dedicated SQL pools in Azure Synapse Analytics

To export a table from an Azure Synapse dedicated SQL pool, you can use several methods, including PolyBase, Azure Data Factory, or the BCP utility. Here’s a brief overview of the process using PolyBase, which is recommended for larger volumes of data due to its performance benefits:

Use PolyBase - This method allows you to load and export data quickly. You can use the CREATE EXTERNAL TABLE statement to define the structure of the table in your dedicated SQL pool and then use the INSERT INTO or SELECT INTO statements to export the data. 

Azure Data Factory - You can create a pipeline in Azure Data Factory to move data from your dedicated SQL pool to another storage location, such as Azure Blob Storage or another SQL database. 

BCP Utility - The Bulk Copy Program (BCP) is a command-line utility that can be used to export data from SQL Server databases, including Azure Synapse dedicated SQL pools.

Note: PolyBase is the best choice when you are loading or exporting large volumes of data, or you need faster performance.

For more details refer to these documentations: Best practices for dedicated SQL pools in Azure Synapse Analytics

Copy exported Dataverse data to dedicated SQL pool

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