Introducing G2.ai, the future of software buying.Try now
Compare Amazon Athena and Snowflake 
At a Glance
Market Segments
Enterprise (50.0% of reviews)
Enterprise (45.5% of reviews)
Entry-Level Pricing
No pricing available
$2 Compute/Hour
Amazon Athena
Star Rating
(201)4.5 out of 5
Market Segments
Enterprise (50.0% of reviews)
Entry-Level Pricing
No pricing available
Learn more about Amazon AthenaSnowflake
Star Rating
(624)4.6 out of 5
Market Segments
Enterprise (45.5% of reviews)
Entry-Level Pricing
$2 Compute/Hour
Free Trial is available
Browse all 4 pricing plansSummary
AI Generated Summary
AI-generated. Powered by real user reviews.
- Users report that Snowflake excels in data replication with a score of 9.0, allowing for seamless data sharing across different environments, while Amazon Athena's replication score is slightly lower at 8.7, which may impact users needing robust data sharing capabilities.
- Reviewers mention that Snowflake's query language is highly rated at 9.3, providing a more intuitive experience for complex queries compared to Amazon Athena's score of 8.6, which some users find less user-friendly for intricate data analysis.
- G2 users highlight Snowflake's superior data management features, scoring 8.9, particularly in data quality and data integration, while Amazon Athena, with a score of 8.6, may not meet the same level of expectations for users focused on comprehensive data governance.
- Reviewers say that Snowflake's performance analysis capabilities, rated at 8.9, provide deeper insights into query performance, whereas Amazon Athena's score of 8.5 indicates that users may experience limitations in performance monitoring and optimization.
- Users on G2 report that Snowflake's data lake integration is rated at 9.3, making it a preferred choice for organizations looking to leverage data lakes effectively, while Amazon Athena's score of 8.8 suggests it may not offer the same level of integration ease.
- Reviewers mention that Snowflake's auto recovery feature, with a score of 9.2, enhances reliability, ensuring minimal downtime, while Amazon Athena's backup score of 8.3 indicates that users may face challenges in data recovery scenarios.
Featured Products
Sponsored
Crescendo.ai
Data Warehouse
Visit Website
Sponsored
RaimaDB
Data Warehouse
Visit Website
Sponsored
Kpow for Apache Kafka®
(4)
Data Warehouse
Visit Website
Pricing
Entry-Level Pricing
Amazon Athena
No pricing availableSnowflake
Standard
$2
Compute/Hour
Compute usage is billed on a per-second basis, with a minimum of 60 seconds. You can secure price discounts with pre-purchased Snowflake capacity options.
- Complete SQL Data Warehouse
- Secure Data Sharing across regions / clouds
- Premier Support 24 x 365
Free Trial
Amazon Athena
No trial information availableSnowflake
Free Trial is available
Ratings
Meets Requirements
8.6
155
9.1
466
Ease of Use
8.8
155
9.0
501
Ease of Setup
9.1
75
8.9
285
Ease of Admin
8.6
71
8.6
194
Quality of Support
8.7
137
8.7
423
Has the product been a good partner in doing business?
8.9
71
9.0
195
Product Direction (% positive)
9.3
129
9.1
436
Features by Category
Deployment
Not enough data
8.8
7
Not enough data
8.3
7
Not enough data
8.8
7
Not enough data
9.0
7
Not enough data
8.8
7
Deployment
Not enough data
8.9
6
Not enough data
9.2
6
Not enough data
9.4
6
Not enough data
9.4
6
Not enough data
9.2
6
Management
Not enough data
8.8
7
Not enough data
8.6
7
Not enough data
8.8
7
Not enough data
8.6
7
Operations
Not enough data
9.2
6
Not enough data
9.2
6
Not enough data
9.2
6
Management
Not enough data
8.6
6
Not enough data
9.0
5
Not enough data
8.6
6
Generative AI
Not enough data
8.9
6
Not enough data
8.6
6
Data Science and Machine Learning PlatformsHide 34 FeaturesShow 34 Features
Not enough data
Not enough data
System
Not enough data
9.3
17
Not enough data
8.8
16
Not enough data
8.2
16
Model Development
Not enough data
9.3
16
Not enough data
8.9
16
Not enough data
8.3
16
Not enough data
8.9
16
Model Development
Not enough data
8.3
16
Not enough data
8.8
16
Not enough data
9.3
16
Machine/Deep Learning Services
Not enough data
8.9
16
Not enough data
8.9
16
Not enough data
8.6
16
Not enough data
8.4
16
Machine/Deep Learning Services
Not enough data
8.9
16
Not enough data
8.6
16
Not enough data
8.2
16
Not enough data
8.8
15
Deployment
Not enough data
9.3
17
Not enough data
9.0
16
Not enough data
9.5
16
Deployment
Not enough data
8.9
15
Not enough data
9.1
15
Not enough data
9.0
15
Generative AI
Not enough data
8.8
15
Not enough data
8.7
15
Not enough data
8.8
15
Agentic AI - Data Science and Machine Learning Platforms
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Data Management
Not enough data
9.0
151
|
Verified
Not enough data
8.9
137
|
Verified
Not enough data
9.0
145
|
Verified
Not enough data
8.3
140
|
Verified
Not enough data
8.3
122
|
Verified
Not enough data
8.8
125
|
Verified
Integration
Not enough data
8.3
112
|
Verified
Not enough data
8.9
140
|
Verified
Not enough data
9.0
131
|
Verified
Deployment
Not enough data
7.8
113
|
Verified
Not enough data
9.2
144
|
Verified
Performance
Not enough data
9.3
147
|
Verified
Security
Not enough data
8.9
137
|
Verified
Not enough data
9.1
148
|
Verified
Generative AI
Not enough data
8.5
52
Not enough data
8.5
53
Management
8.0
27
9.0
69
8.7
25
9.2
69
8.6
31
9.4
74
8.5
29
8.8
72
8.5
29
9.1
73
Maintenance
8.0
28
9.3
71
8.3
27
8.9
70
8.1
27
9.3
71
Security
9.0
29
9.2
71
9.1
31
9.2
73
Storage
Not enough data
9.2
41
Not enough data
9.1
41
Availability
Not enough data
9.1
36
Not enough data
9.2
34
Not enough data
9.2
38
Performance
Not enough data
9.2
41
Security
Not enough data
9.1
41
Not enough data
9.2
42
Not enough data
9.0
35
Not enough data
9.2
35
Support
Not enough data
9.3
33
Not enough data
9.1
32
Centralized computation
Not enough data
9.3
23
Localized computation
Not enough data
9.0
22
Data
Not enough data
9.7
6
Not enough data
9.4
6
Interaction
Not enough data
9.7
6
Not enough data
9.7
6
Not enough data
9.7
6
Not enough data
9.2
6
Not enough data
9.4
6
Learning
Not enough data
9.7
6
Not enough data
9.2
6
Content Generation
Not enough data
9.2
6
Not enough data
9.4
6
System
Not enough data
10.0
6
Not enough data
9.7
6
Not enough data
9.4
6
Not enough data
9.4
6
Agentic AI - AI Chatbots
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Configuration
8.8
41
Not enough data
8.4
37
Not enough data
8.7
38
Not enough data
8.4
35
Not enough data
8.9
36
Not enough data
Database Administration
8.9
35
Not enough data
9.0
37
Not enough data
8.9
38
Not enough data
Availability
9.0
40
Not enough data
9.1
37
Not enough data
8.8
37
Not enough data
8.9
37
Not enough data
Security
8.8
35
Not enough data
9.2
35
Not enough data
9.0
33
Not enough data
Data Management
9.0
35
Not enough data
9.1
41
Not enough data
Database
Not enough data
8.9
88
Not enough data
9.3
91
Not enough data
9.3
85
Integrations
Not enough data
8.8
67
Not enough data
8.8
72
Platform
Not enough data
9.2
82
Not enough data
9.1
88
Not enough data
8.8
72
Processing
Not enough data
9.3
86
Not enough data
9.1
85
Data Transformation
Not enough data
9.3
73
Not enough data
9.3
73
Connectivity
Not enough data
8.6
65
Not enough data
8.8
66
Not enough data
9.1
67
Not enough data
9.1
68
Operations
Not enough data
8.5
70
Not enough data
9.2
66
Not enough data
9.0
62
Not enough data
8.9
67
Not enough data
8.8
64
Building Reports
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Platform
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Categories
Categories
Shared Categories
Amazon Athena and Snowflake are categorized as Database Management Systems (DBMS)
Unique Categories
Amazon Athena is categorized as Database as a Service (DBaaS)
Reviews
Reviewers' Company Size
Amazon Athena
Small-Business(50 or fewer emp.)
Mid-Market(51-1000 emp.)
Enterprise(> 1000 emp.)
Snowflake
Small-Business(50 or fewer emp.)
Mid-Market(51-1000 emp.)
Enterprise(> 1000 emp.)
Small-Business
(50 or fewer emp.)
Mid-Market
(51-1000 emp.)
Enterprise
(> 1000 emp.)
Reviewers' Industry
Computer Software
14.7%
Information Technology and Services
14.2%
Financial Services
7.4%
Retail
4.2%
Marketing and Advertising
4.2%
Other
55.3%
Information Technology and Services
14.4%
Computer Software
13.0%
Financial Services
10.2%
Marketing and Advertising
4.0%
Hospital & Health Care
4.0%
Other
54.3%
Most Helpful Reviews
Amazon Athena
Most Helpful Favorable Review
Arjun S.
Verified User in Education Management
I've been working on Athena as well as Bigquery. Athena's querying speeds are insane. One of the best available Data Warehouses out there.No hassles when it comes to integrate it with other AWS tools.
Most Helpful Critical Review
Verified User in Computer & Network Security
Athena could have a better looking user interface
Snowflake
Most Helpful Favorable Review
Rijul S.
Verified User in Food Production
Ease of usage Fast in memory querying Fast query response Seamless integration with dbt [data build tool] Easy to learn and understand Easy to implement with existing data engineering pipelines and solutions Support is very fast and effective can be...
Most Helpful Critical Review
Verified User in Internet
My main disappointment was with their support. We had an issue as soon as we signed a contract and it was about billing which seemed to be pushed off with no urgency and still not completed. Something like this I would have expected to be resolved within...
Arjun S.
Verified User in Education Management
I've been working on Athena as well as Bigquery. Athena's querying speeds are insane. One of the best available Data Warehouses out there.No hassles when it comes to integrate it with other AWS tools.
Rijul S.
Verified User in Food Production
Ease of usage Fast in memory querying Fast query response Seamless integration with dbt [data build tool] Easy to learn and understand Easy to implement with existing data engineering pipelines and solutions Support is very fast and effective can be...
Verified User in Computer & Network Security
Athena could have a better looking user interface
Verified User in Internet
My main disappointment was with their support. We had an issue as soon as we signed a contract and it was about billing which seemed to be pushed off with no urgency and still not completed. Something like this I would have expected to be resolved within...
Alternatives
Discussions
Is AWS Athena free?
1 comment
JI
NoRead more
How do I use AWS Athena?
1 comment
BV
AWS Management Console
Command Line Interface (CLI)
JDBC/ODBC Drivers
WS Serverless Application RepositoryRead more
Amazon Athena has no more discussions with answers
What's the best way to manage change data capture in Snowflake?
4 comments
VT
You might get a relevant answer from it.Read more
which is best snowflake or My sql
2 comments
LH
Depends on your needs. MySQL is open source/free. It or Postgres (another open source db) is good for pretty much any normal need. You can install on...Read more
What is the difference between Snowflake vs Redshift? Which one is Good to Learn.
2 comments
DW
I've used both; Snowflake is superior in my view. Redshift certainly offers a lot of power being an AWS product, however Snowflake is more fully-featured....Read more
Hunting for software insights?
With over 2.5 million reviews, we can provide the specific details that help you make an informed software buying decision for your business. Finding the right product is important, let us help.
