AWS Athena vs your own Presto cluster on AWS

I just published Easily deploying Presto on AWS with Terraform, but ignored a very important question: AWS offers Athena for SQL over S3, which is essentially a Presto deployment managed by AWS. Why not just use AWS Athena instead of going through the trouble of deploying your own cluster?

I probably should have addressed this in the original blog post, but since I didn't - let's do the complete reasoning for when you should (and shouldn't) consider your own Presto cluster.

Cost per query

The main reason to prefer your own Presto cluster is significant cost savings.

With Athena cost is per query with a price of $5 per TB scanned. If your organization has a lot of data but only few queries per day, then Athena is definitely the economic choice. However, if your company is data-driven and has a team of analysis and BI users then it's a completely different story. Their dashboards and queries will be in the dozens if not hundreds or thousands per day, and possibly scanning many TBs of data each.

By deploying Presto yourself you can drastical...

Elasticsearch training courses

I've got a few training courses - hand-on worshops rather - on Elasticsearch and the ELK stack coming up, so I thought it'd be a good idea to blog about them and spread the word out.

Interested in a training near you or in your company? feel free to reach out, or check my [Elasticsearch consultan...

Showing 10 posts out of 127 total, page 1

Next page