Chapter 5: Integrating Data into Your Modern Data Warehouse

Extracting data from source systems and incorporating it into your modern data warehouse is one of the most important pieces of the foundation that you will create in relation to your analytical data estate.

The sheer number of possible different source formats can leave you scratching your head when you are confronted with the requirements of your users and how quickly they require their analyses and reports.

In this chapter, you will learn how to implement ETL/ELT (Extract, Transform, Load/Extract, Load, Transform) pipelines with Synapse pipelines or alternatively using Azure Data Factory. This depends on your choice of services and whether you are using the integrated Synapse experience ...

Get Cloud Scale Analytics with Azure Data Services 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.