Loading data to Azure Synapse Analytics using Azure Data Factory

In this recipe, we will look further at how to load data into Azure Synapse Analytics using Azure Data Factory.

Getting ready

Before we start, please ensure that you have created a linked service to a Blob storage container and know how to create a Copy Data statement in Azure Data Factory. Please refer to Chapter 2, Orchestration and Control Flow, for guidelines on how to do that.

How to do it…

To load data into Azure Synapse Analytics using Azure Data Factory, use the following steps:

1. Before we create a Copy Data statement in Azure Data Factory, we need to create a new table in Azure Synapse Analytics:

   CREATE TABLE [dbo].[Planes]
   ([Name] varchar(100) NOT NULL,
   [IATA_code] varchar(10) NULL,
   [ICAO_code] varchar(10) NULL)

2. Open Azure Data Factory and launch the Copy data tool (as seen in the following screenshot), then select the linked service to Azure Blob storage or create a new one (refer...