Migrate to scalable database in AWS

[namanaman]

Currently on Google Sheets, with a row limit of 2 million and a rate limit of 60 requests per minute

Requirements

• Scalable
• Secure (is encryption necessary?)
• Can be visualized (AWS QuickSight, Looker Studio)

Potential options to store

• Lambda --> DynamoDB
• Lambda --> SQS --> RDS

Potential options to visualize

• DB <-- Lambda <-- Google File Storage <-- Looker Studio
• DB <-- Lambda <-- AWS S3 <-- AWS QuickSight
• DB <-- Lambda <-- BigQuery (needs to be public?) <-- Looker Studio
• DB <-- Lambda <-- Redshift (needs to be public?) <-- Looker Studio or QuickSight