Amazon athena is simply sql queries that helps much to verify data stored in various formats in s3. Review collected by and hosted on G2.com.

Some joins over multiple tables or subqueries are much slower for user prospective. Review collected by and hosted on G2.com.

AWS Athena and its interactive, serverless, querying interface, is what I like the most, apart from its lightweight yet the highly efficient query-execution environment Review collected by and hosted on G2.com.

Nothing specific, I think AWS Athena does pretty well what its meant to do, I think what Athena can really use is maybe a better integration with Non-AWS services in near future Review collected by and hosted on G2.com.

Once the data is createdin Athena, the data is dynamic . Additional cost is not required to extra storage Review collected by and hosted on G2.com.

Nothing as of now. Have not seen any drawback as such Review collected by and hosted on G2.com.

Simple and user friendly UI

Can easily visualise s3 files in athena Review collected by and hosted on G2.com.

Athena should be connected to more aws service Review collected by and hosted on G2.com.

Aws support team is very supportive if req any support from them. Review collected by and hosted on G2.com.

Nothing as such. Everything is in shape and they developing the things as and when req Review collected by and hosted on G2.com.

Ease of use

Simple UI interface

Connects to S3

Cheaper than redshift Review collected by and hosted on G2.com.

Query management is lagging

Unable to maintain qury within GUI Review collected by and hosted on G2.com.

Access was very easy directly from s3. Which was very easy and effective way to access the data file in s3 Review collected by and hosted on G2.com.

What a software like product to query istead using the console athena Review collected by and hosted on G2.com.

so there is no infrastructure to manage, and you pay only for the queries that you run Review collected by and hosted on G2.com.

nothing.so there is no infrastructure to manage Review collected by and hosted on G2.com.

It is easy to use. You can run queries in the cloud with low latency. You can store the queries in excel in the s3 bucket and run those queries in athena with AWS python SDK. Review collected by and hosted on G2.com.

Nothing. But they can improve their query error message. Every time if something wrong in the query you will not see which components have errors. You will see only the error message. Review collected by and hosted on G2.com.

Scalability and managment capabilities. Easiest to scale up and down on the go allong with having optuons for cross site replication and other such functionalities helping in a production ready deployment. Review collected by and hosted on G2.com.

I have found it complicated to set one up or explain the process of setting one up Review collected by and hosted on G2.com.