data-engineer-test-task-python-sql

According to the task you need:

• load data from json file to sqlite3
• normalize data
• write some sql queries for data

How to check it

1. Create sqlite database using the creating script.
   Database schema:
   

2. Load data using the tool tweet_loader according to the readme.

3. Test data loading with sql queries:

   • happiest county script
   • happiest location script
   • happiest user tweets script