Etl

Airflow on Azure: App Service, Synapse, and Blob Storage

Book: Data Pipelines with Apache Airflow
Authors: Bas Harenslak and Julian deRuiter
ISBN: 9781617296901

Azure gets the same treatment AWS got in the previous chapter. Map Airflow components to managed services, survey the provider package, then build the movie-ranking pipeline again. Same goal, different cloud.

Airflow on AWS: Fargate, S3, Glue, and a Movie Ranking DAG

Book: Data Pipelines with Apache Airflow
Authors: Bas Harenslak and Julian deRuiter
ISBN: 9781617296901

Chapter 16 is where the cloud chapters get concrete. Harenslak and deRuiter map every Airflow component to an AWS service, then build a working movie-ranking pipeline with S3, Glue, and Athena.

Lambda Architecture, DAGs, and Apache Airflow Lab

Book: Data Engineering for Beginners
Author: Chisom Nwokwu
ISBN: 9781394325412

The second half of Chapter 7 answers a question every data team hits eventually: how do you run live dashboards AND historical reports without building two completely separate systems? Then it gets practical with orchestration and a hands-on Airflow lab.

Data Warehouses, Data Lakes, and Lakehouses Explained

Chapter 6 of Data Engineering for Beginners by Chisom Nwokwu (ISBN 9781394325412) is a big one. It moves beyond traditional databases into the storage systems that power modern analytics. The fictional bakery Dough & Delight runs through every example, which keeps things grounded.

Cleaning, Transforming, and Enriching Data With Pandas

Book: Data Engineering with Python
Author: Paul Crickard
ISBN: 978-1-83921-418-9


Chapters 3 and 4 taught you how to move data in and out of files and databases. Chapter 5 asks the next obvious question: what do you do with the data in the middle? Often the answer is clean it, reshape it, and sometimes bolt on extra context from another source. Crickard uses real Albuquerque e-scooter trip data for all of this, which makes the examples feel grounded instead of toy-like.

Data Engineering With Python: A Hands-on Book Walkthrough

Book: Data Engineering with Python
Author: Paul Crickard
ISBN: 978-1-83921-418-9
Publisher: Packt (October 2020)


I’m starting a walkthrough of Data Engineering with Python by Paul Crickard. This is not a copy-paste summary. It’s my retelling of each chapter with notes on what stuck, what felt dated, and what still holds up.

Data Engineering With AWS Chapter 7 Part 2: Transforming Data - Optimization and Business Logic

This is post 12 in my Data Engineering with AWS retelling series.

In Part 1, we covered the generic data preparation transforms: converting to Parquet, partitioning, PII protection, and data cleansing. Those transforms work on individual datasets and do not need much business context. Now we get to the transforms that actually create business value. The ones that combine multiple datasets, add context, flatten structures, and produce the tables that analysts and dashboards consume.

Data Engineering With GCP Chapter 1: What Is Data Engineering Anyway?

Chapter 1 starts with a confession most of us in the data world can relate to. Adi Wijaya says he used to think data was clean. Neatly organized, ready to go. Then he actually worked with data in real organizations and realized most of the effort goes into collecting, cleaning, and transforming it. Not the fun machine learning part. The plumbing part.