Quick, powerful analytical tools. Uses familiar syntax. Uses S3 buckets to build the database. Allow several queries to be saved. Review collected by and hosted on G2.com.

Navigating AWS can be difficult at times. May not be as fast as some other solutions. Review collected by and hosted on G2.com.

I have worked on multiple databases so far. I found it to be better than traditional hive systems.

Within a minute the queries run for many gigabytes of storage.

On top of that, no need to have a system to run.

Since it is a service, anybody can login on web and see the data.

It predominantly helped me serve product people where they can tweak my query and do things on their own when usually I was involved everytime. Review collected by and hosted on G2.com.

I did not like some integration with languages like R. RJDBC package had some bugs. Review collected by and hosted on G2.com.

serverless architecture no requried infrastructure to manage.

pay only for what we queries we run, its make cost effecitve.

it supports major all the file formats example parquet, json, text and many more

we can integrate with aws glue service for ETL jobs.

due to serverless its more in performance. Review collected by and hosted on G2.com.

its less performance when we query on large datasets.

it has limited ETL functionalities when we compare to other services.

its highly dependent on s3 service. Review collected by and hosted on G2.com.

It is very easy, cost efficient and time saving solution to create ETLs, manage your metadata and quickly query from the untyped data present in S3 Review collected by and hosted on G2.com.

Amazon Athena should work on optimizing the process of running the query over big data. Sometimes, we have to use thrift servers just to query fast on big data.

Other point is error messages should be more precise. Review collected by and hosted on G2.com.

Pricing and ease to use, you can do queries of data with SQL syntax Review collected by and hosted on G2.com.

Not all SQL syntax allowed, you can't create tables from a query. Review collected by and hosted on G2.com.

You can write SQL-like queries to access data on S3. The user does not require to adopt a new skill to use Athena. Review collected by and hosted on G2.com.

The performance gets hit with the volume of data. Review collected by and hosted on G2.com.

I like that it uses the S3 files in the backend and uses distributed computing to doing queries on those files.

It uses Postgres SQL in the backend and I like that bacuase the queries for this would not be outdated. Review collected by and hosted on G2.com.

It is a great tool for stakeholder to look in the data when the queries are there and weasy to modify and use on web.

But integration sometimes causes issues when data has to be pulled. The problem I faced is only for a few systems when working on older laguages. Review collected by and hosted on G2.com.

There are number of AWS services that many data driven companies use. This makes Athena a feasible and efficient to store and analyse data. It also supports data partitioning which has improved the performance when running tedeous queries which is a frequent task for Data professionals. Review collected by and hosted on G2.com.

Not all format of data is effectively analysed. We often have to priorities parquet format when working with Athena is involved. Also there can be diffulties when working in complicated data. Cleaner data is better analyzed in Athena. Review collected by and hosted on G2.com.

Athena is helpful to query on data lakes for adhoc analysis of business data. Athena combined with glue crawlers is an excellent combination for ingesting data from multiple sources. Review collected by and hosted on G2.com.

Stored procedures are not supported in athena, that's a drawback. Many common sql statements like ctas, merge, update is not supported in athena limiting its analytical usage. Review collected by and hosted on G2.com.

Amazon Athena can be easily used to process and query large amount of data weather stored in S3 bucket or any other data source. Use Athena with aws glue to rapidly create database table and you are ready to query your data using structured query language. Review collected by and hosted on G2.com.

Athena supports most of the type of data but there are some edge cases in type of data where we cannot create a database table and query data using aws Athena. A user in such cases generally face issue of SER-DER is not a valid. Review collected by and hosted on G2.com.