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
Choosing a data loading option
Data loading is one of the most important aspects ...
Get Azure Synapse Analytics Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
