Amazon Athena Reviews & Product Details

It is easy to use Athena, whether you are a tech or a non-tech person. It has a very user-friendly interface, and the thing that I like the most is that you can query many types of source input data. Review collected by and hosted on G2.com.

I don't find it helpful when I need to query the data and make updates. Review collected by and hosted on G2.com.

Amazon athena is very powerful serverless solution and it's very cost-effective. I like the user-friendly interface that athena provides to query data from any table present in the S3. I use athena to query data almost on a regular basis. The customer support is also very helpful with the queries regarding anything. It was very easy to implement because of very powerful documentation provided by AWS. Review collected by and hosted on G2.com.

There are very few things that I don't like about athena, like occasional lags when querying large datasets, there are also some features missing that could have helped the user a lot. Review collected by and hosted on G2.com.

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.