TrustRadius

Amazon Athena vs. Delta Lake

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
Amazon Athena
Score 8.6 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
Delta Lake
Score 10.0 out of 10
N/A
Delta Lake is an open source project that enables building a Lakehouse architecture on top of data lakes. Delta Lake provides ACID transactions, scalable metadata handling, and unifies streaming and batch data processing on top of existing data lakes, such as S3, ADLS, GCS, and HDFS.
$0
per month
Pricing
Amazon AthenaDelta Lake
Editions & Modules
Price per Query
$5.00
per TB of Data Scanned
No answers on this topic
Offerings
Pricing Offerings
Amazon AthenaDelta Lake
Free Trial
NoNo
Free/Freemium Version
NoYes
Premium Consulting/Integration Services
NoNo
Entry-level Setup FeeNo setup feeNo setup fee
Additional Details——
More Pricing Information
Community Pulse
Amazon AthenaDelta Lake
Features
Amazon AthenaDelta Lake
Database-as-a-Service
Comparison of Database-as-a-Service features of Product A and Product B
Amazon Athena
8.6
4 Ratings
0% above category average
Delta Lake
-
Ratings
Automatic software patching8.22 Ratings00 Ratings
Database scalability9.03 Ratings00 Ratings
Automated backups7.73 Ratings00 Ratings
Database security provisions9.22 Ratings00 Ratings
Monitoring and metrics8.04 Ratings00 Ratings
Automatic host deployment9.22 Ratings00 Ratings
Best Alternatives
Amazon AthenaDelta Lake
Small Businesses
IBM Cloudant
IBM Cloudant
Score 7.4 out of 10

No answers on this topic

Medium-sized Companies
IBM Cloudant
IBM Cloudant
Score 7.4 out of 10
Snowflake
Snowflake
Score 8.7 out of 10
Enterprises
IBM Cloudant
IBM Cloudant
Score 7.4 out of 10
Snowflake
Snowflake
Score 8.7 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
Amazon AthenaDelta Lake
Likelihood to Recommend
10.0
(4 ratings)
-
(0 ratings)
Usability
10.0
(1 ratings)
-
(0 ratings)
User Testimonials
Amazon AthenaDelta Lake
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.
Scott Kennedy | TrustRadius Reviewer
Scott Kennedy
Sr Director, BI
Read full review
Open Source
No answers on this topic
Pros
Amazon AWS
  • Nested Schemas like JSON data structure
  • Ability to adapt the data model to fit your queries better
  • Performance Improvement
RK
Riyaz Khan
Data Engineer
Read full review
Open Source
No answers on this topic
Cons
Amazon AWS
  • Response caching can be improved.
  • Data Partitioning is tricky and understanding of the same could be improved.
Alok Pabalkar | TrustRadius Reviewer
Alok Pabalkar
Co-Founder & CTO
Read full review
Open Source
No answers on this topic
Usability
Amazon AWS
Easy to use. Scalable. Gets the job of data warehousing setup done. Using the datalake on S3 has become super convenient.
Alok Pabalkar | TrustRadius Reviewer
Alok Pabalkar
Co-Founder & CTO
Read full review
Open Source
No answers on this topic
Alternatives Considered
Amazon AWS
Verified User
Anonymous
Read full review
Open Source
No answers on this topic
Return on Investment
Amazon AWS
  • 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.
Scott Kennedy | TrustRadius Reviewer
Scott Kennedy
Sr Director, BI
Read full review
Open Source
No answers on this topic
ScreenShots