Amazon Athena vs. Google Cloud Dataflow

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
Amazon Athena
Score 8.4 out of 10
N/A
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 and begin using standard SQL to run ad-hoc queries and get results in seconds. Athena is serverless, so there is no infrastructure to setup or manage, and customers pay only for the queries they run. You can use Athena to process logs, perform ad-hoc analysis, and run…
$5
per TB of Data Scanned
Google Cloud Dataflow
Score 7.9 out of 10
N/A
Google offers Cloud Dataflow, a managed streaming analytics platform for real-time data insights, fraud detection, and other purposes.N/A
Pricing
Amazon AthenaGoogle Cloud Dataflow
Editions & Modules
Price per Query
$5.00
per TB of Data Scanned
No answers on this topic
Offerings
Pricing Offerings
Amazon AthenaGoogle Cloud Dataflow
Free Trial
NoNo
Free/Freemium Version
NoNo
Premium Consulting/Integration Services
NoNo
Entry-level Setup FeeNo setup feeNo setup fee
Additional Details
More Pricing Information
Community Pulse
Amazon AthenaGoogle Cloud Dataflow
Top Pros

No answers on this topic

Top Cons

No answers on this topic

Features
Amazon AthenaGoogle Cloud Dataflow
Database-as-a-Service
Comparison of Database-as-a-Service features of Product A and Product B
Amazon Athena
8.5
3 Ratings
3% below category average
Google Cloud Dataflow
-
Ratings
Automatic software patching8.22 Ratings00 Ratings
Database scalability8.22 Ratings00 Ratings
Automated backups7.73 Ratings00 Ratings
Database security provisions9.22 Ratings00 Ratings
Monitoring and metrics8.73 Ratings00 Ratings
Automatic host deployment9.22 Ratings00 Ratings
Streaming Analytics
Comparison of Streaming Analytics features of Product A and Product B
Amazon Athena
-
Ratings
Google Cloud Dataflow
7.5
1 Ratings
8% below category average
Real-Time Data Analysis00 Ratings8.01 Ratings
Data Ingestion from Multiple Data Sources00 Ratings8.01 Ratings
Low Latency00 Ratings8.01 Ratings
Linear Scale-Out00 Ratings7.01 Ratings
Machine Learning Automation00 Ratings7.01 Ratings
Data Enrichment00 Ratings7.01 Ratings
Best Alternatives
Amazon AthenaGoogle Cloud Dataflow
Small Businesses
SingleStore
SingleStore
Score 9.8 out of 10
Amazon Kinesis
Amazon Kinesis
Score 8.0 out of 10
Medium-sized Companies
SingleStore
SingleStore
Score 9.8 out of 10
Confluent
Confluent
Score 7.4 out of 10
Enterprises
SingleStore
SingleStore
Score 9.8 out of 10
Spotfire Streaming
Spotfire Streaming
Score 8.1 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
Amazon AthenaGoogle Cloud Dataflow
Likelihood to Recommend
9.5
(3 ratings)
8.0
(1 ratings)
User Testimonials
Amazon AthenaGoogle Cloud Dataflow
Likelihood to Recommend
Amazon AWS
If you are looking to take a lot of the traditional "database administration" work off someone's plate, going with Amazon Athena certainly has "no code" options to optimize lots of database tasks. I would say this option is less appropriate if you have other Microsoft things at play, such as Power BI.
Read full review
Google
Based on my experience, streaming / real time / machine learning / AI type of processing and batch processing which needs less transformation are very well suited. Work load that needs complex transformation / multiple hops gets very complicated to implement. New feature like Dataflow SQL option will come in handy for sql heavy users.
Read full review
Pros
Amazon AWS
  • Nested Schemas like JSON data structure
  • Ability to adapt the data model to fit your queries better
  • Performance Improvement
Read full review
Google
  • Streaming, Real time work load
  • Batch processing
  • Auto scaling
  • flexible pricing
Read full review
Cons
Amazon AWS
  • Query manager can incoperate GUI based query designer
  • Auto-completion engine sometimes overwrite the query
  • Time range selection should be implicit
Read full review
Google
  • inbuild template options can be expanded
  • more data connector options
  • easy of use
Read full review
Alternatives Considered
Amazon AWS
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.
Read full review
Google
Google Cloud Dataproc Cloud Datafusion
Read full review
Return on Investment
Amazon AWS
  • Easy to query terabytes of data with faster response
  • Pricing model is also cheap
  • No indexing and partitioning
Read full review
Google
  • cost saving from managing our own data center for ETL servers
  • consumption based pricing
  • with auto scaling feature, we were able to expand components to support work load
Read full review
ScreenShots