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.
5,134 questions
How to export a table from azure synapse dedicated DB pool
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(214.4, 7.000000000000001%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN%3C/text%3E%3C/svg%3E)
Naresh
0
Reputation points
How to export a table from azure synapse dedicated DB pool
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(201.6, 18%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGG%3C/text%3E%3C/svg%3E)
Ganesh Gurram 3,110 Reputation points Microsoft Vendor2025-01-08T03:17:14.2566667+00:00 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.
-
Ganesh Gurram 3,110 Reputation points Microsoft Vendor
2025-01-09T03:59:07.1733333+00:00 @Naresh - We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
-
Nandan Hegde 33,241 Reputation points MVP2025-01-09T05:28:13.8533333+00:00 Can you confirm where do you want to export the data from the dedicated pool?
-
Ganesh Gurram 3,110 Reputation points Microsoft Vendor
2025-01-10T04:35:04.77+00:00 @Naresh - Following up to see if the above suggestion was helpful. And, if you have any further query do let us know.
Sign in to comment
Sign in to answer