All work
06Data Engineering

Airflow Data Pipeline

Synthetic sales pipeline with Kafka + Airflow + PostgreSQL — full-load batch plus real-time streaming.

Architecture

Synthetic sales data via both full-load batch and real-time Kafka streaming into PostgreSQL, with Airflow orchestrating scheduled transforms.

Data GeneratorSynthetic sales (CSV)
Apache KafkaReal-time streaming
PostgreSQLFull-load + JDBC sink
Dimension TablesScheduled SQL

Orchestration

Apache Airflow

Ingestion

Kafka JDBC Sink

Infrastructure

Docker

Overview

A data pipeline over synthetic sales data combining two ingestion modes: full-load batch and real-time streaming.

Kafka handles streaming ingestion, Airflow orchestrates the batch workflows, and PostgreSQL serves as the destination store.

Highlights

  • Both full-load batch and real-time streaming in one pipeline
  • Orchestrated with Apache Airflow

Tech stack

KafkaApache AirflowPostgreSQL