AWS Athena: From S3 to Insight.
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.
- 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

Comments
Please log in to join the conversation