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.

Videos

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

Code & Dataset

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

Project Experience

Add project experience to your Linkedin/Github profiles.

Customer Love

Read All Reviews

SUBHABRATA BISWAS

Lead Consultant, ITC Infotech

The project orientation is very much unique and it helps to understand the real time scenarios most of the industries are dealing with. And there is no limit, one can go through as many projects... Read More

Hiren Ahir

Microsoft Azure SQL Sever Developer, BI Developer

I'm a Graduate student and came into the job market and found a university degree wasn't sufficient to get a good paying job. I aimed at hottest technology in the market Big Data but the word BigData... Read More

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.
 

Similar Projects

In this project, we will evaluate and demonstrate how to handle unstructured data using Spark.

Analyze clickstream data of a website using Hadoop Hive to increase sales by optimizing every aspect of the customer experience on the website from the first mouse click to the last.

Explore hive usage efficiently in this hadoop hive project using various file formats such as JSON, CSV, ORC, AVRO and compare their relative performances

Curriculum For This Mini Project