Mapping Data Flows in Azure Data Factory: Building Scalable Etl Projects in the Microsoft Cloud

ISBN-13: 9781484286111 / Angielski / Miękka / 2022

Mark Kromer

Opis

Build scalable ETL data pipelines in the cloud using Azure Data Factory’s Mapping Data Flows. Each chapter of this book addresses different aspects of an end-to-end data pipeline that includes repeatable design patterns based on best practices using ADF’s code-free data transformation design tools. The book shows data engineers how to take raw business data at cloud scale and turn that data into business value by organizing and transforming the data for use in data science projects and analytics systems. 

The book begins with an introduction to Azure Data Factory followed by an introduction to its Mapping Data Flows feature set. Subsequent chapters show how to build your first pipeline and corresponding data flow, implement common design patterns, and operationalize your result. By the end of the book, you will be able to apply what you’ve learned to your complex data integration and ETL projects in Azure. These projects will enable cloud-scale big analytics and data loading and transformation best practices for data warehouses.

What You Will Learn

• Build scalable ETL jobs in Azure without writing code
• Transform big data for data quality and data modeling requirements
• Understand the different aspects of Azure Data Factory ETL pipelines from datasets and Linked Services to Mapping Data Flows
• Apply best practices for designing and managing complex ETL data pipelines in Azure Data Factory
• Add cloud-based ETL patterns to your set of data engineering skills
• Build repeatable code-free ETL design patterns

Who This Book Is For

Data engineers who are new to building complex data transformation pipelines in the cloud with Azure; and  data engineers who need ETL solutions that scale to match swiftly growing volumes of data

Intermediate user level

Spis treści

Introduction

Part I. Getting Started with Azure Data Factory and Mapping Data Flows 

1. Introduction to Azure Data Factory

2. Introduction to Mapping Data Flows

Part II. Designing Scalable ETL Jobs with ADF Mapping Data Flows

3. Build Your First Pipeline

4. Common Pipeline Patterns

5. Design Your First Mapping Data Flow

6. Common Data Flow Patterns

7. Debugging Mapping Data Flows

8. Data Pipelines with Data Flows

Part III. Operationalize your ETL Data Pipelines

9. CI/CD and Scheduling

10. Monitoring, Management, and Security

Part IV. Sample Project

11. Build a New ETL Project in ADF using Mapping Data Flows

12. End-to-End Review of the ADF Project 

O autorze

​Mark Kromer has been in the data analytics product space for over 20 years and is currently a Principal Program Manager for Microsoft’s Azure data integration products. Mark often writes and speaks on big data analytics and data analytics and was an engineering architect and product manager for Oracle, Pentaho, AT&T, and Databricks prior to Microsoft Azure.

Blurb

Build scalable ETL data pipelines in the cloud using Azure Data Factory’s Mapping Data Flows. Each chapter of this book addresses different aspects of an end-to-end data pipeline that includes repeatable design patterns based on best practices using ADF’s code-free data transformation design tools. The book shows data engineers how to take raw business data at cloud scale and turn that data into business value by organizing and transforming the data for use in data science projects and analytics systems. 

The book begins with an introduction to Azure Data Factory followed by an introduction to its Mapping Data Flows feature set. Subsequent chapters show how to build your first pipeline and corresponding data flow, implement common design patterns, and operationalize your result. By the end of the book, you will be able to apply what you’ve learned to your complex data integration and ETL projects in Azure. These projects will enable cloud-scale big analytics and data loading and transformation best practices for data warehouses.

What You Will Learn

• Build scalable ETL jobs in Azure without writing code
• Transform big data for data quality and data modeling requirements
• Understand the different aspects of Azure Data Factory ETL pipelines from datasets and Linked Services to Mapping Data Flows
• Apply best practices for designing and managing complex ETL data pipelines in Azure Data Factory
• Add cloud-based ETL patterns to your set of data engineering skills
• Build repeatable code-free ETL design patterns