Another stimulating project completed at SPICED Accademy. The goal of this project was to build a Dashboard with Metabase running on AWS and based on a Postgres database on Amazon RDS. The dashboard summurizes data from the "Nothwind Traders" a fictional company.
A Postgres database was creted first locally, then remotly. The csv tables composing the DB were loaded using SQL COPY command in the northwind.sql file that I wrote for creating the tables and copying data from the csv-files (check the path!).
Python scripts and ASLAlchemy library was used to access the DB using Python. After this a dump file was created and later on used to load the DB on the amazon RDS.
Metabase was installed on an AWS EC2 Machine and used for creating a publically available Metabase dashboard (not available anymore: EC2 stopped and RDS deleted).