ETL pipeline that converts specific JSON object and seed relational database
-
Updated
Aug 1, 2020 - Python
ETL pipeline that converts specific JSON object and seed relational database
Built an ETL pipeline that extracts their data from S3, stages them in Redshift, and transforms data into a set of dimensional tables. Load data from S3 to staging tables on Redshift and execute SQL statements that create the analytics tables from these staging tables.
This repository is about a project to create a datawarehouse and ETL pipeline on AWS for a music streaming app. They will define Fact and Dimension tables and insert data into new tables. At the end, I'm going to process two analytical queries to check it out the top ten artists and songs.
Apache Kafka Streamlit application for real-time tracking of pharmacy sales using the start schema data model.
Add a description, image, and links to the starschema topic page so that developers can more easily learn about it.
To associate your repository with the starschema topic, visit your repo's landing page and select "manage topics."