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.
-
Notifications
You must be signed in to change notification settings - Fork 1
sharkawy98/data_modelling
Folders and files
Name | Name | Last commit message | Last commit date | |
---|---|---|---|---|
Repository files navigation
About
Modeling a star schema in PostgreSQL from JSON files
Resources
Stars
Watchers
Forks
Releases
No releases published
Packages 0
No packages published