Copying data in Azure Synapse Integrate

In this recipe, you will create a Copy Data pipeline using Azure Synapse Integrate tool and export data from a dedicated SQL Pool into a data lake.

Getting ready

You need to have access to an Azure Synapse workspace which has a dedicated SQL pool. The SQL pool should have table Customer (refer to recipe Loading data to Azure Synapse Analytics using bulk load for instructions on how to create this table and load data)

How to do it…

To export data using Azure Synapse Integration, follow these steps:

1. Open your Azure Synapse workspace and go to Integrate tab

2. Select Add a new resource, choose Pipeline, then add a Copy data activity to your pipeline, and rename it:

   

   Figure 3.43 – Creating a new pipeline with the Integrate tool of the Synapse Analytics workspace

3. In the Source section, create a new source dataset with Azure Synapse Dedicated SQL Pool as a data store. Configure data set properties by giving it an appropriate name, and...