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:
- Before we create a Copy Data statement in Azure Data Factory, we need to create a new table in Azure Synapse Analytics. To do that, open Synapse Studio, go to the Data tab on the left side of your screen, and click New SQL script on a schema for which you want to create a new table, then click New table:
Figure 3.9: Creating a new table in Azure Synapse Analytics
- Run the following...
