Reading the article it’s clear pretty quickly that Uber was using DynamoDB poorly. It seems they need strong consistency for certain CUJs and then a lot of data warehousing for historical transactions. It’s strange to me that they didn’t first convert their 2 table DynamoDB architecture into DynamoDB and Redshift architecture or similar. This is a pretty common pattern.
Can you post some references to this pattern?
You can also look into “realtime data warehousing”.
Meanwhile, it’s so common, AWS built it into their product.
https://aws.amazon.com/about-aws/whats-new/2023/11/amazon-dy...