I have a use case to query request url from S3 logs. Amazon has recently introduced Athena to query S3 file contents. What is the best option with respect to cost and performance?
- Use Athena to query S3 files for request urls
- Store metadata of each file with request url information in DynamoDB table for query