Introducing G2.ai, the future of software buying.Try now
Compare Amazon Athena and Snowflake 
Featured Products
Sponsored
You’re seeing this ad based on the product’s relevance to this page. Sponsored content does not receive preferential treatment in any of G2’s ratings.
Starburst
Visit Website
Sponsored
You’re seeing this ad based on the product’s relevance to this page. Sponsored content does not receive preferential treatment in any of G2’s ratings.
Alteryx
Visit Website
At a Glance
Market Segments
Enterprise (51.0% of reviews)
Enterprise (44.9% of reviews)
Entry-Level Pricing
No pricing available
$2 Compute/Hour
Amazon Athena
Star Rating
(165)4.4 out of 5
Market Segments
Enterprise (51.0% of reviews)
Pros & Cons
Entry-Level Pricing
No pricing available
Learn more about Amazon AthenaSnowflake
Star Rating
(666)4.6 out of 5
Market Segments
Enterprise (44.9% of reviews)
Pros & Cons
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.
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.4
121
9.1
502
Ease of Use
8.8
121
9.0
538
Ease of Setup
9.1
56
8.9
323
Ease of Admin
8.5
55
8.6
203
Quality of Support
8.5
103
8.7
459
Has the product been a good partner in doing business?
8.7
55
9.0
204
Product Direction (% positive)
9.1
96
9.2
472
Features by Category
Deployment
Not enough data
9.2
12
Not enough data
8.9
12
Not enough data
9.0
12
Not enough data
9.3
12
Not enough data
9.3
12
Deployment
Not enough data
9.3
10
Not enough data
9.5
10
Not enough data
9.5
10
Not enough data
9.5
10
Not enough data
9.3
10
Management
Not enough data
9.2
12
Not enough data
9.0
12
Not enough data
9.2
12
Not enough data
9.0
12
Operations
Not enough data
8.8
10
Not enough data
8.8
10
Not enough data
9.5
10
Management
Not enough data
9.2
10
Not enough data
9.3
9
Not enough data
9.0
10
Generative AI
Not enough data
8.7
10
Not enough data
8.3
10
System
Not enough data
9.2
28
Model Development
Not enough data
9.1
27
Not enough data
8.5
27
Not enough data
8.3
27
Not enough data
8.7
27
Model Development
Not enough data
8.7
27
Machine/Deep Learning Services
Not enough data
8.6
27
Not enough data
8.6
27
Not enough data
8.4
27
Not enough data
8.4
26
Machine/Deep Learning Services
Not enough data
8.5
27
Not enough data
8.5
24
Deployment
Not enough data
9.1
29
Not enough data
9.0
27
Not enough data
9.3
27
Generative AI
Not enough data
8.4
25
Not enough data
8.3
25
Not enough data
8.5
25
Agentic AI - Data Science and Machine Learning Platforms
Not enough data
8.2
13
Not enough data
8.2
13
Not enough data
8.3
13
Not enough data
8.5
13
Not enough data
8.2
13
Not enough data
8.3
13
Not enough data
8.2
12
Data Management
Not enough data
9.0
182
|
Verified
Not enough data
8.9
167
|
Verified
Not enough data
9.0
174
|
Verified
Not enough data
8.3
169
|
Verified
Not enough data
8.2
150
|
Verified
Not enough data
8.7
153
|
Verified
Integration
Not enough data
8.2
140
|
Verified
Not enough data
8.9
168
|
Verified
Not enough data
8.8
159
|
Verified
Deployment
Not enough data
7.8
140
|
Verified
Not enough data
9.2
174
|
Verified
Performance
Not enough data
9.2
178
|
Verified
Security
Not enough data
8.9
165
|
Verified
Not enough data
9.1
176
|
Verified
Generative AI
Not enough data
8.0
79
Not enough data
8.1
80
Management
8.0
27
8.9
83
8.7
25
9.2
83
8.6
31
9.5
88
8.5
29
9.0
86
8.5
29
9.1
87
Maintenance
8.0
28
9.3
85
8.3
27
9.0
84
8.1
27
9.3
85
Security
9.0
29
9.2
85
9.1
31
9.2
88
Storage
Not enough data
9.2
44
Not enough data
9.2
44
Availability
Not enough data
9.1
39
Not enough data
9.2
37
Not enough data
9.2
41
Performance
Not enough data
9.2
44
Security
Not enough data
9.1
44
Not enough data
9.2
45
Not enough data
8.9
38
Not enough data
9.2
38
Support
Not enough data
9.2
36
Not enough data
9.1
35
Centralized computation
Not enough data
9.3
25
Localized computation
Not enough data
9.0
24
Configuration
8.8
42
Not enough data
8.5
38
Not enough data
8.8
39
Not enough data
8.3
36
Not enough data
9.0
37
Not enough data
Database Administration
8.9
36
Not enough data
9.0
38
Not enough data
8.9
39
Not enough data
Availability
9.0
41
Not enough data
8.9
38
Not enough data
8.7
38
Not enough data
8.7
38
Not enough data
Security
8.8
36
Not enough data
9.2
36
Not enough data
9.0
34
Not enough data
Data Management
9.1
36
Not enough data
9.1
42
Not enough data
Database
Not enough data
8.9
98
Not enough data
9.3
101
Not enough data
9.3
95
Integrations
Not enough data
8.6
76
Not enough data
8.7
81
Platform
Not enough data
9.1
91
Not enough data
9.0
97
Not enough data
8.7
81
Processing
Not enough data
9.3
96
Not enough data
9.1
94
Data Transformation
Not enough data
9.2
86
Not enough data
9.4
86
Connectivity
Not enough data
8.5
78
Not enough data
8.7
79
Not enough data
9.1
80
Not enough data
9.1
81
Operations
Not enough data
8.6
83
Not enough data
9.2
79
Not enough data
8.9
75
Not enough data
8.8
80
Not enough data
8.7
77
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
Information Technology and Services
14.2%
Computer Software
12.3%
Financial Services
8.4%
Retail
4.5%
Pharmaceuticals
4.5%
Other
56.1%
Information Technology and Services
14.4%
Computer Software
12.9%
Financial Services
10.4%
Marketing and Advertising
4.7%
Hospital & Health Care
3.8%
Other
53.8%
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
Please go through this link: https://docs.snowflake.com/en/user-guide/streams
You might get a pertinent response from it.
Please click on this link...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 3 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.
