AWS Athena is one of those dream services. At least on paper. I can ship my log data to AWS S3 and query it via SQL. What’s not to like? You could replace Splunk, Aurora DB, RDS, etc. Right?
Potentially if you have infrequent needs or are fine with higher latency queries. And like most things AWS, you pay by the drink. The critical price knob for Athena is the size of the dataset you need to query. You can query 1TB of data for $5.00 for each query. The results are returned to S3 in seconds or minutes.
So if your query responses aren’t time-sensitive and infrequent, Athena may be the service for you. It’s much less headache than managing a high-performance solution such as Splunk and cheaper than paying for Aurora or RDS.
From the iPhone of Corey Quinn
Will it Database