By reading the AWS Athena documentation - we realize that this service provides a way to make queries on stored files in S3 through traditional SQL and without going through an ETL. That's the basic idea.
But I do not know exactly what motivation to use this service is. Is it some kind of Elastic service?