README.md

About

• Udacity assignment for Data Engineer Nanodegree
• Create a Postgres database with tables designed to optimize queries on song play analysis

Files and Directories

• data
  • datasets for ETL processes
• create_tables.py
  • script for create tables
• sql_queries.py
  • containing sql queries
• test.ipynb
  • test script (jupyter notebook script)

How to Use

1. run create_table.py

2. run etl.py

3. run test.ipynb to show table rows to check whether create_table.py and etl.py worked correctly