Chapter 1: Choosing the Optimal Method for Loading Data to Synapse
In this chapter, we will cover how to enrich and load data to Azure Synapse using the most optimal method. We will be covering, in detail, different techniques to load data, considering the variety of data source options. We will learn the best practices to be followed for different data loading options, along with unsupported scenarios.
We will cover the following recipes:
- Choosing a data loading option
- Achieving parallelism in data loading using PolyBase
- Moving and transforming using a data flow
- Adding a trigger to a data flow pipeline
- Unsupported data loading scenarios
- Data loading best practices