Amazon Athena is a serverless offering provided by AWS that analyzes data in S3 buckets using SQL. You can partition your data into individual folders to make it easier for Athena to query the data allowing you to run queries on specific subsets of data. Having your files remain above 128 MB instead of having several smaller files can also prevent overhead on Amazon Athena. Now Athena sounds interesting, but it can only use S3 right? You can actually use Amazon Athena with other databases through lambda Data Source Connector to run “federated queries”, queries that can be ran outside of S3 into relational, non-relational and customer data sources in order to run analytics on your data without having to move any existing data to Amazon S3. In order to create an SQL table to analyze the data on your S3 bucket I would highly recommend checking out the following link
https://docs.aws.amazon.com/AmazonS3/latest/userguide/using-s3-access-logs-to-identify-requests.html