AWS Athena allows querying files stored in S3. AWS Kinesis Firehose allows streaming data to S3. But for efficient querying you need to split your data in partitions. Here is how you can automate the process using AWS Lambda

DynamoDB is capable of automatic scaling and I put this feature under test to better understand how it works. See my findings in the post

In this tutorial, I present a simple dependency-free starter kit which uses CloudFormation to help you manage NodeJS Lambda functions