Skip to content

Modeling a star schema in PostgreSQL from JSON files

Notifications You must be signed in to change notification settings

sharkawy98/data_modelling

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

3 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

PostgreSQL data modelling project from Udacity DE nanodegree

Here is the generated star schema of the data collected from JSON files:

star_schema

Description of what each file is doing:

  • test.ipynb displays few rows of each table to validate the work done.
  • create_tables.py drops and creates the tables, to rest the tables if you want.
  • etl.py reads and processes all files from song_data and log_data and loads them into the tables.
  • sql_queries.py contains all sql queries, and is imported into the last three files above.

About

Modeling a star schema in PostgreSQL from JSON files

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published