Jaehyeon Kim
Jaehyeon Kim

  • Blog
    • Categories

      List of categories.

    • Tags

      List of tags.

    • Series

      List of series.

    • Archives

  • Projects
  • Slides

/

  • Github Linkedin RSS

  • Font Size
  • Palette
  • Mode
  1. Home
  2. Tags
  3. AWS

Data Build Tool (dbt) Pizza Shop Demo - Part 6 ETL on Amazon Athena via Airflow

Data Build Tool (dbt) Pizza Shop Demo - Part 6 ETL on Amazon Athena via Airflow
March 14, 20248 min read Data-Engineering Dbt Pizza Shop DemoAmazon AthenaApache AirflowAWSDbtDockerPython

Orchestrate the Amazon Athena and Iceberg pizza shop dbt project with Apache Airflow, running the dimension and denormalised fact table builds.

Read More: Data Build Tool (dbt) Pizza Shop Demo - Part 6 ETL on Amazon Athena via Airflow

Data Build Tool (dbt) Pizza Shop Demo - Part 5 Modelling on Amazon Athena

Data Build Tool (dbt) Pizza Shop Demo - Part 5 Modelling on Amazon Athena
March 7, 202416 min read Data-Engineering Dbt Pizza Shop DemoAmazon AthenaAWSDbtDockerPython

Model pizza shop data as Apache Iceberg tables transformed on Amazon Athena with dbt, using array and struct types to denormalise the fact table.

Read More: Data Build Tool (dbt) Pizza Shop Demo - Part 5 Modelling on Amazon Athena

Consume data from Kafka using Lambda - Real Time Streaming with Kafka and Flink Lab 6

Consume data from Kafka using Lambda - Real Time Streaming with Kafka and Flink Lab 6
December 14, 20236 min read Data-Streaming Real Time Streaming With Kafka and FlinkAmazon MSKApache KafkaAWSAWS LambdaKpowPython

Consume Kafka messages with an AWS Lambda function, using Amazon MSK as an event source so that Lambda polls the topic and invokes the function.

Read More: Consume data from Kafka using Lambda - Real Time Streaming with Kafka and Flink Lab 6

Setup Local Development Environment for Apache Flink and Spark Using EMR Container Images

Setup Local Development Environment for Apache Flink and Spark Using EMR Container Images
December 7, 202317 min read Data-Engineering Data-Streaming DevelopmentAmazon EMRApache FlinkApache KafkaApache SparkAWSDocker

A local Flink and Spark environment built from EMR container images, where Flink ingests data in real time and Spark queries it via the Glue Data Catalog.

Read More: Setup Local Development Environment for Apache Flink and Spark Using EMR Container Images

Write data to DynamoDB using Kafka Connect - Real Time Streaming with Kafka and Flink Lab 5

Write data to DynamoDB using Kafka Connect - Real Time Streaming with Kafka and Flink Lab 5
November 30, 202310 min read Data-Streaming Real Time Streaming With Kafka and FlinkAmazon DynamoDBApache FlinkApache KafkaAWSKafka ConnectKpow

Ingest records from a Kafka topic into a DynamoDB table using the Camel DynamoDB sink connector, defined and run on Kafka Connect.

Read More: Write data to DynamoDB using Kafka Connect - Real Time Streaming with Kafka and Flink Lab 5

Transform and write data to S3 from Kafka using Flink - Real Time Streaming with Kafka and Flink Lab 3

Transform and write data to S3 from Kafka using Flink - Real Time Streaming with Kafka and Flink Lab 3
November 16, 202316 min read Data-Streaming Real Time Streaming With Kafka and FlinkAmazon S3Apache FlinkApache KafkaAWSKpowPyFlinkPython

Export Kafka topic messages to S3 with PyFlink, enriching records through a user defined function and querying them on Athena through a Glue table.

Read More: Transform and write data to S3 from Kafka using Flink - Real Time Streaming with Kafka and Flink Lab 3

Write data to Kafka from S3 using Flink - Real Time Streaming with Kafka and Flink Lab 2

Write data to Kafka from S3 using Flink - Real Time Streaming with Kafka and Flink Lab 2
November 9, 202315 min read Data-Streaming Real Time Streaming With Kafka and FlinkAmazon S3Apache FlinkApache KafkaAWSDockerKpowPyFlink

Read records from S3 and send them into a Kafka topic with PyFlink, using a custom pipeline jar for IAM authentication, which is useful for enrichment.

Read More: Write data to Kafka from S3 using Flink - Real Time Streaming with Kafka and Flink Lab 2

Deploy Aiven OpenSearch Sink Connector - Kafka Connect for AWS Services Integration Part 5

Deploy Aiven OpenSearch Sink Connector - Kafka Connect for AWS Services Integration Part 5
October 30, 202318 min read Data-Streaming Kafka Connect for AWS Services IntegrationAmazon MSKAmazon OpenSearch ServiceApache KafkaAWSKafka ConnectKpow

Deploy a Kafka to OpenSearch pipeline on AWS with Terraform, covering a VPC, VPN server, MSK cluster, OpenSearch domain and the MSK Connect connectors.

Read More: Deploy Aiven OpenSearch Sink Connector - Kafka Connect for AWS Services Integration Part 5

Produce data to Kafka using Lambda - Real Time Streaming with Kafka and Flink Lab 1

Produce data to Kafka using Lambda - Real Time Streaming with Kafka and Flink Lab 1
October 26, 202314 min read Data-Streaming Real Time Streaming With Kafka and FlinkAmazon EventBridgeAmazon MSKApache KafkaAWSAWS LambdaKpowPython

Produce fake taxi ride data into a Kafka topic on Amazon MSK from an AWS Lambda function invoked repeatedly by an EventBridge schedule rule.

Read More: Produce data to Kafka using Lambda - Real Time Streaming with Kafka and Flink Lab 1

Develop Aiven OpenSearch Sink Connector - Kafka Connect for AWS Services Integration Part 4

Develop Aiven OpenSearch Sink Connector - Kafka Connect for AWS Services Integration Part 4
October 23, 202312 min read Data Integration Data-Streaming Kafka Connect for AWS Services IntegrationApache KafkaAWSDockerKafka ConnectKpowOpenSearch

Build a local Kafka to OpenSearch pipeline on Docker with the Aiven sink connector, ingesting fake impressions and clicks for near real time analytics.

Read More: Develop Aiven OpenSearch Sink Connector - Kafka Connect for AWS Services Integration Part 4
  • ««
  • «
  • 1
  • 2
  • 3
  • 4
  • 5
  • »
  • »»
Profile
Jaehyeon Kim
Jaehyeon Kim
Data Engineer | Data Streaming | Powering ML & AI in Real Time
Taxonomies
Data Streaming 70 Data Engineering 41 Development 28 Data Analysis 17 Data Integration 12 Open Source 11 Machine Learning 7 Kubernetes 6 Security 5 Data Architecture 3 Data Processing 3 Big Data 2 System Architecture 2 Web Development 2
Python 75 Apache Kafka 71 AWS 50 Docker 50 Apache Flink 36 Apache Beam 17 Apache Spark 16 Kafka Connect 16 Amazon MSK 14 AWS Lambda 14 dbt 13 Amazon EMR 11 odctl 11 dynamic-des 10 PostgreSQL 9 Kubernetes 8 PyFlink 8 Debezium 7 Kotlin 7 Apache Airflow 6 Change Data Capture (CDC) 6 Kafka UI 6 Amazon DynamoDB 5 Apache Iceberg 5 Discrete Event Simulation 5 PySpark 5 Amazon API Gateway 4 Amazon Athena 4 AWS Glue 4 AWS Glue Schema Registry 4 BigQuery 4 Digital Twin 4 FastAPI 4 Minikube 4 SimPy 4 Amazon EKS 3 Amazon QuickSight 3 Amazon S3 3 Apache Hudi 3 EMR on EKS 3 ALL 142
Kafka Development with Docker 11 Apache Beam Python Examples 10 Real Time Streaming with Kafka and Flink 7 dbt Pizza Shop Demo 6 Apache Beam Local Development with Python 5 Building Real-Time Digital Twins with dynamic-des 5 dbt for Effective Data Transformation on AWS 5 Getting Started with Real-Time Streaming in Kotlin 5 Kafka Connect for AWS Services Integration 5 Serverless Data Product 4 Data Lake Demo Using Change Data Capture 3 Getting Started with PyFlink on AWS 3 Kafka Development on Kubernetes 3 Parallel processing on single machine 3 Realtime Dashboard with FastAPI, Streamlit and Next.js 3 API development with R 2 dbt Guide for Production 2 Deploy Python Stream Processing App on Kubernetes 2 Download Stock Data 2 From Prototype to Production: Real-Time Product Recommendation with Contextual Bandits 2 ALL 25
2026 15 2025 13 2024 29 2023 39 2022 15 2021 7 2020 1 2019 5 2018 2 2017 6 2016 6 2015 15 2014 5
Posts
  • Live Game Leaderboards with Kafka, Flink SQL and a Discrete-Event Simulation
    Live Game Leaderboards with Kafka, Flink SQL and a Discrete-Event Simulation
    October 2, 2026
  • Change Data Capture on a Simulated Online Shop with Debezium and Kafka Connect
    Change Data Capture on a Simulated Online Shop with Debezium and Kafka Connect
    October 1, 2026
  • Introducing Benchtop: Data Streaming and Machine Learning Projects You Can Run Locally
    Introducing Benchtop: Data Streaming and Machine Learning Projects You Can Run Locally
    September 30, 2026
  • Learning MLOps with a Feature Store: A New Series
    Learning MLOps with a Feature Store: A New Series
    September 28, 2026
  • Building an Agentic Analytics System over an Iceberg Lakehouse
    Building an Agentic Analytics System over an Iceberg Lakehouse
    July 18, 2026
  • Dynamic DES v0.11.1: A Declarative API with Postgres and Redis Connectors
    Dynamic DES v0.11.1: A Declarative API with Postgres and Redis Connectors
    July 17, 2026
  • Introducing odctl: One CLI for a Local Open Data Stack
    Introducing odctl: One CLI for a Local Open Data Stack
    July 16, 2026
  • One Simulation, Two Pipelines: Batch Training and Live Inference with Dynamic DES v0.8.1
    One Simulation, Two Pipelines: Batch Training and Live Inference with Dynamic DES v0.8.1
    May 25, 2026
  • Building an Event-Driven Hybrid Digital Twin with dynamic-des
    Building an Event-Driven Hybrid Digital Twin with dynamic-des
    April 29, 2026
  • Why Digital Twins Are Rewiring Industry 4.0
    Why Digital Twins Are Rewiring Industry 4.0
    April 22, 2026
  • Live Game Leaderboards with Kafka, Flink SQL and a Discrete-Event Simulation
    Live Game Leaderboards with Kafka, Flink SQL and a Discrete-Event Simulation
    October 2, 2026
  • Change Data Capture on a Simulated Online Shop with Debezium and Kafka Connect
    Change Data Capture on a Simulated Online Shop with Debezium and Kafka Connect
    October 1, 2026
  • Introducing Benchtop: Data Streaming and Machine Learning Projects You Can Run Locally
    Introducing Benchtop: Data Streaming and Machine Learning Projects You Can Run Locally
    September 30, 2026
  • Learning MLOps with a Feature Store: A New Series
    Learning MLOps with a Feature Store: A New Series
    September 28, 2026
  • Building an Agentic Analytics System over an Iceberg Lakehouse
    Building an Agentic Analytics System over an Iceberg Lakehouse
    July 18, 2026
  • Dynamic DES v0.11.1: A Declarative API with Postgres and Redis Connectors
    Dynamic DES v0.11.1: A Declarative API with Postgres and Redis Connectors
    July 17, 2026
  • Introducing odctl: One CLI for a Local Open Data Stack
    Introducing odctl: One CLI for a Local Open Data Stack
    July 16, 2026
  • One Simulation, Two Pipelines: Batch Training and Live Inference with Dynamic DES v0.8.1
    One Simulation, Two Pipelines: Batch Training and Live Inference with Dynamic DES v0.8.1
    May 25, 2026
  • Current London 2026: Building End-to-End Data Lineage
    Current London 2026: Building End-to-End Data Lineage
    May 22, 2026
  • Building an Event-Driven Hybrid Digital Twin with dynamic-des
    Building an Event-Driven Hybrid Digital Twin with dynamic-des
    April 29, 2026
Actions
Go back Reload Copy URL

Jaehyeon Kim

Data Engineer | Data Streaming | Powering ML & AI in Real Time

Copyright © 2023-2026 Jaehyeon Kim. All Rights Reserved.