AWS Athena: From S3 to Insight.
January 08, 2025

AWS Athena: From S3 to Insight.

Alok Pabalkar | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User

Overall Satisfaction with Amazon Athena

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.

Pros

  • Log Analysis.
  • Real Time Reports.
  • Data Integration with other components. Makes ML Data ingestion super easy.

Cons

  • Response caching can be improved.
  • Data Partitioning is tricky and understanding of the same could be improved.
  • It's easy to store and query data on S3. Multiple teams can query the same data to generate their reports. It removes the need for a full-fledged data warehouse for a startup. Saves costs.
  • Improved team efficiency on monitoring user activities by easy logging and reporting.
  • As the dataset gets heavier on S3, one needs to understand partitioning and that leads to the requirement of expertise.
Easy to use. Scalable. Gets the job of data warehousing setup done. Using the datalake on S3 has become super convenient.
- Super Cost-Effective - Well integrated with the AWS ecosystem - Easy setup with multiple formats.

Do you think Amazon Athena delivers good value for the price?

Yes

Are you happy with Amazon Athena's feature set?

Yes

Did Amazon Athena live up to sales and marketing promises?

Yes

Did implementation of Amazon Athena go as expected?

Yes

Would you buy Amazon Athena again?

Yes

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.

Amazon Athena Feature Ratings

Database scalability
9
Monitoring and metrics
8

Comments

More Reviews of Amazon Athena