Amazon Athena - Faster and interactive query processing engine on Amazon S3
In my current organization, we use Amazon Athena for querying data from AWS S3 location. It provides faster access to data as compared to …
Starting at $5 per TB of Data Scanned
View PricingOverview
What is Amazon Athena?
Amazon Athena is an interactive query service that makes it easy to analyze data directly in Amazon S3 using standard SQL. With a few clicks in the AWS Management Console, customers can point Athena at their data stored in S3…
Recent Reviews
Pricing
Price per Query
$5.00
Cloud
per TB of Data Scanned
Entry-level set up fee?
- No setup fee
Offerings
- Free Trial
- Free/Freemium Version
- Premium Consulting/Integration Services
Product Details
- About
- Tech Details
What is Amazon Athena?
Amazon Athena Technical Details
| Deployment Types | Software as a Service (SaaS), Cloud, or Web-Based |
|---|---|
| Operating Systems | Unspecified |
| Mobile Application | No |
Comparisons
Compare with
Reviews and Ratings
(38)Reviews
(1-3 of 3)Companies can't remove reviews or game the system. Here's why
In my current organization, we use Amazon Athena for querying data from AWS S3 location. It provides faster access to data as compared to the traditional relational database management system. Also, it helps to work with complex data structures such as JSON, Parquet, CSV, and Avro. Earlier we were using some traditional RDBMS for reporting Ecommerce related KPIs which has lots of transactional data coming in. Performance was not much good for querying huge amount of real-time inventory data. So, we moved to Amazon Athena to support fast interactive querying of data and processing.
- Nested Schemas like JSON data structure
- Ability to adapt the data model to fit your queries better
- Performance Improvement
- Complex query optimization
- Limited performance on AWS S3
- Partioning and columnar format to maximize MPP
96.66666666666666%
9.7
- Easy to query terabytes of data with faster response
- Pricing model is also cheap
- No indexing and partitioning
- Amazon Redshift and Amazon EMR (Elastic MapReduce)
Amazon Redshift and EMR require explicit configuration for underlying compute infrastructure. In Amazon Athena, Users don't have to set up any underlying infrastructure. It saves a lot of costs required for infrastructure. Users have to pay only for scanned data. Athena is good for ad-hoc query analysis without setting up any infrastructure.
August 30, 2022
Didn't knew I could do a lot more with this
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.
- Load Balance traffic analysis
- Big data report generation
- Micro services pattern query analysis
- Query manager can incoperate GUI based query designer
- Auto-completion engine sometimes overwrite the query
- Time range selection should be implicit
21.666666666666664%
2.2
- We have saved about 30% team bandwidth using Athena
- We have saved about 100$ a month using athena for our analytics
July 25, 2022
Great value for the money
We use Amazon Athena to overlay a bunch of direct-to-consumer click stream data. The most common queries are looking at attribution analysis. Things like first touch attribution versus last touch attribution. The data volume is significant and we needed an easy way to pull insights from our data stores and hand them back to the marketing business side users. At the end of the day, SQL is a very popular language to use for 99% of data problems.
- The most obvious, is you can use SQL programming language, which a lot of people understand.
- You can scale up to meeting higher processing times.
- The data return speed (query speed) is great.
- Every dialect of SQL has some missing functions. I wish there was automated GROUP BY options here.
- There are connection problems back to Power BI occasionally.
- If you don't watch certain queries, it's possible that it takes a long time to run and charges you a lot of money.
76.66666666666667%
7.7
- The query speeds help us make more decisions in a day (speed).
- If you need more horsepower for specific times in the day this option helps scale.
- The security of your environment is well protected too.
- Azure Synapse Analytics (Azure SQL Data Warehouse)
Amazon Athena, a product from Amazon, competes with offerings from Google and Microsoft. Overall, I think your database choice depends on some of the other applications you are running at your company. For example, if you are using Microsoft Power BI for reporting needs, you might want to consider going the Azure route.