Streaming ETL in Kafka with KSQL using NYC TLC Data

Streaming ETL in Kafka with KSQL using NYC TLC Data

In this project, we will show how to build an ETL pipeline on streaming datasets using Kafka.
explanation image

Videos

Each project comes with 2-5 hours of micro-videos explaining the solution.

ipython image

Code & Dataset

Get access to 102+ solved projects with iPython notebooks and datasets.

project experience

Project Experience

Add project experience to your Linkedin/Github profiles.

Customer Love

What will you learn

Kafka Connectors (Source and Sink)
Deploy HBase Sink Connector
ETL with Kafka Streaming application
Joining two separate streams of data
Discuss Apache Kafka vs Confluent Kafka
Introduction to KSQL

Project Description

In this Hackerday, we will show by demonstrating how to build an ETL pipeline on streaming datasets using Kafka. We will be using the trips and fares dataset from the New York Taxi and Limousine Commission to demonstrate how to get data in real-time, join it to other streaming datasets, and store the data in a database.

Will be answering questions like reporting the income of drivers every hour, find the drivers around a certain location at any point in time amongst other things.
 

New Projects

Curriculum For This Mini Project

Latest Blogs