What are the usecases for AWS Athena database?

AWS Athena is SQL querying service to query data from S3.

Most of the time we used are mainly for reporting as it supports major reporting tools through JDBC connector and ODBC tools. Particularly we have some csv control files gets dropped into s3 that has some information about the process/factors for our particular date process.

It supports most of the types of data type like CSV, TSV, JSON, Textfile and other ORC formats. Used it to query data from different formats and test the data format , for designing our hive tables.