Crawlers can be scheduled .

Kafka makes the select on the data seem less.

ANSI SQL support.

Best application to crawl through source files for data analytics. The staging of file can be avoided to see the data with in it . Review collected by and hosted on G2.com.

UI could have been better.

The schedule should be more configurable.

The table partition at times goes wrong.

Access other cloud storage will help for various business needs. Review collected by and hosted on G2.com.

Supporting the presto SQL model for easy querying for real time data Review collected by and hosted on G2.com.

Costs is major factor and can not support some query models Review collected by and hosted on G2.com.

Easy to connect to any data source and start querying Review collected by and hosted on G2.com.

There is nothing specific that I dislike about this Review collected by and hosted on G2.com.

host of fucntionalities that athena provides Review collected by and hosted on G2.com.

frequent changes and support required for some Review collected by and hosted on G2.com.

Amazon Athena is something that I use almost everyday to create table and analyze my huge-volume data, I'm a data analyst and I happen to read , query and use TBs of our data for which Amazon Athena is my go to tool, the most exciting part is that is almost like a sql workbench and you can query upon Athena using QSL queries which makes it easy to use and seemless to peruse my data, basically, you can use the simple storage service to store any volume of data, create Athena tables over it and query your data, most importantly you are only charged for the queries that you run on your tables, the whole thing is serverless and self managed by Amazon you need not worry about the infrastructure as its already been taken care off, the queries that you run are parallelly processed and this saves you a lot of time are the it can process terrabytes of data in seconds.

Summary of above:

-You can run SQL scripts over Athena Tables,

-Athena can read huge data within seconds,

-Its fast and allows you to download queried data as comma separated files. Review collected by and hosted on G2.com.

Nothing specific to dislike, its easy to use, reliable and fast. However, like alwasy Amazon products are a bit pricey when compared to its competitors in the segment, the pricing could be lowered a bit but definately comensates for the quality. Review collected by and hosted on G2.com.

Athena helps with data lineage by analyzing data from S3 buckets and many other sources including Snowflake. Review collected by and hosted on G2.com.

Stored procedures are not supported and you could reach performance issues if too many partitions. Review collected by and hosted on G2.com.

the best advantage of amazon athena in my opinion is the simplicity of configuration and use: Athena does not require any infrastructure configuration and users can start running ad hoc queries within minutes. Review collected by and hosted on G2.com.

The biggest disadvantage is the limitation of queries: Athena has limitations on query size and resource utilisation, which may limit its ability to handle complex queries on large data sets. At least for now. Review collected by and hosted on G2.com.

The Amazon Athena Query editor is very user friendly. If the SQL query is not correct, it shows the exact line with the error and also suggests how to resolve the error Review collected by and hosted on G2.com.

In case of huge data processing, the cost increases a lot. For clients with less data Athena costs won't be huge. But clients with huge amount of data will cost a lot and using AWS Redshift is better for such clients Review collected by and hosted on G2.com.

The best thing which I like about the service is its ease to use , one can easily use it or integrate with thier code, also as it's queries are very much similar to sql it make more easier Review collected by and hosted on G2.com.

There are few data source integration which is not so easy with Athena ,

Also it's a little slow on fetching the result when a particular query is done as it stores the data at se level Review collected by and hosted on G2.com.

AWS console and the reporting and customer care service regarding any downtime. In fact, there is very less downtime. Review collected by and hosted on G2.com.

The cost is very high compared to other providers. And the transparency of pricing for each module after the purchase. Review collected by and hosted on G2.com.