Load EcoPlaftform data from S3 to PostgreSQL

[aduverger]

High-level design:

Overall logic:
Each time a json file is created or modified in the epd-raw-data-prod-eu-west-3 bucket, it sends an event to a SNS.
A SQS listens to this SNS and triggers a lambda that will read the json, and load its data into PostgreSQL.

UUID can be used for indexing the DB.
Maybe for v0 we can load everything into the same table?

Resources to create with cdk:

• PostgreSQL (using aws-rds)
• S3 Event notifications (modify existing S3 bucket)
• SNS Topic
• SQS + Dead-Letter Queue
• Python Lambda to read json file and insert the data into PostgreSQL