Data is extracted from a directory of JSON logs on user activity and a directory with JSON metadata on the songs in the app. Database is consisted of mainly five tables (songplays, users, songs, artists, time) and is designed to optimize queries on song play analysis. Songplays is the Fact table while other four are Dimension tables.

Open the terminal and go inside the project directory and run the following commands

python create_tables.py 

python etl.py

You can use test.ipynb file to check the data stored in tables.