Amazon Athena Information Reviews & Insights

We generate lots of user action data from the platform, which is saved in S3 via AWS Firehose Kinesis. These logs are queried occasionally for debugging ETL or business-specific reporting purposes. We use Athena to run SQL-like queries and generate structured reports.

Suitable for: - Log Level Analysis - Reporting Queries - Web Analytics Not Suitable for: - Realtime Streaming Data as it has low latency - Low latency queries as it does take some time to generate the response.

We extensively use AWS Load balancers and a lot of traffic needs retrospection. Athena makes it quite simple and useful to query our traffic and analyze the service architecture. We also use AWS S3 extensively. Athena makes it quite simple to query around half a million records daily. We have tried other open source tools, none of which has been able to work in as fewer efforts as Athena did. I would definitely recommend it to others.

We use Athena extensively on our load balance traffic analyser. It helps us filter out bad requests and reason them quickly. Hence, a useful toolkit for monitoring stack We also use Athena on our report generation on a million per day datasets. It helps report generation quickly and easily on daily basis, which would've taken a lot of engineering efforts.