This is pretty much straight from the DynamoDB best practices. Offload infrequently accessed data (think time series data from previous months) to S3 and use another tool to query it.
https://docs.aws.amazon.com/amazondynamodb/latest/developerg...
https://docs.aws.amazon.com/amazondynamodb/latest/developerg...
Now I've learned to read the Best Practices section of any AWS service before I start implementing. It saves a lot of heartache