Data Engineering Nanodegree

This project loads data from music streaming .json files and inserts it into postgresql in a relational model.

Prerequisites:

Step 1 - Create tables in to PostgreSQL

python create_tables.py

Step 2 - Load data from .json files into tables

python etl.py

Step 3 - Test if records successfully added into tables Run jupyter notebook test.ipynb

Project tables

Tables

Name		Name	Last commit message	Last commit date
Latest commit History 8 Commits
data		data
docs		docs
exercises		exercises
README.md		README.md
create_tables.py		create_tables.py
etl.ipynb		etl.ipynb
etl.py		etl.py
sql_queries.py		sql_queries.py
test.ipynb		test.ipynb