staging-tables

Udacity Data Engineering Nanodegree

FAA Airline On-Time Performance Data

Cloud Data Warehouse of Sparkify Data using Redshift

A tiny and temporary db for quick data cleansing and transformation. It is a high-level python coding and would help any Pythonistas up to speed with ETL work.

applying data warehouses tools and AWS to build an ETL pipeline for a database hosted on Redshift. loading data from AWS S3 bucket to staging tables on Redshift and executing SQL statements that create the analytics tables from these staging tables.

Applying data modeling to a NoSQL database with Apache Cassandra and build an ETL pipeline using Python. And modeling the data by creating tables in Apache Cassandra to run queries.

This project demonstrates Snowflake table cloning and swapping techniques. It covers creating original and cloned tables, loading data from S3, verifying cloned data, and performing table swaps to efficiently exchange data between staging and production tables.

Loading data from Amazon S3 bucket to staging tables on Amazon Redshift then extracting Analytics tables from them.