For analytical are exploratory work, it still would be much more sensible to use DynamoDB streams with a simple Lambda and write it to an Aurora Serverless Postgres/MySQL table.
The tradeoff of doing aggregations and joins in memory just isn’t worth it.