Amazon Athena vs. DataGrip

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
Amazon Athena
Score 9.1 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
DataGrip
Score 8.8 out of 10
N/A
DataGrip, from JetBrains, is a database IDE that is tailored to suit the specific needs of professional SQL developers.
$9.90
per month per user
Pricing
Amazon AthenaDataGrip
Editions & Modules
Price per Query
$5.00
per TB of Data Scanned
For Individuals
$99
per year per user
For Organizations
$229
per year per user
All Products Pack for Individuals
$289
per year per user
All Products Pack for Organizations
$779
per year per user
Offerings
Pricing Offerings
Amazon AthenaDataGrip
Free Trial
NoYes
Free/Freemium Version
NoNo
Premium Consulting/Integration Services
NoNo
Entry-level Setup FeeNo setup feeNo setup fee
Additional Details
More Pricing Information
Features
Amazon AthenaDataGrip
Database-as-a-Service
Comparison of Database-as-a-Service features of Product A and Product B
Amazon Athena
8.6
4 Ratings
1% below category average
DataGrip
-
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.14 Ratings00 Ratings
Automatic host deployment9.22 Ratings00 Ratings
Best Alternatives
Amazon AthenaDataGrip
Small Businesses
IBM Cloudant
IBM Cloudant
Score 7.7 out of 10
PyCharm
PyCharm
Score 9.0 out of 10
Medium-sized Companies
IBM Cloudant
IBM Cloudant
Score 7.7 out of 10
PyCharm
PyCharm
Score 9.0 out of 10
Enterprises
IBM Cloudant
IBM Cloudant
Score 7.7 out of 10
PyCharm
PyCharm
Score 9.0 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
Amazon AthenaDataGrip
Likelihood to Recommend
10.0
(4 ratings)
8.7
(5 ratings)
Usability
10.0
(1 ratings)
8.5
(2 ratings)
User Testimonials
Amazon AthenaDataGrip
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
JetBrains
You will like DataGrip; it is the best software to channel and influence data systems and efficiently. It will help you be more efficient and productive in exporting computer data; it is very effective. There are no errors, and you will feel comfortable using them. It promotes data quality and has excellent graphics to represent your information through statistical processes.
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
JetBrains
  • I like and enjoy this tool because it is intuitive and straightforward; its interface and panels are for managing local and remote databases.
  • It is beneficial and powerful for database administration and has extensive support for handling multiple database engines.
  • DataGrip's features and functionalities are excellent; they make our work easier and faster.
  • We can manage several databases at the same time.
Read full review
Cons
Amazon AWS
  • Response caching can be improved.
  • Data Partitioning is tricky and understanding of the same could be improved.
Read full review
JetBrains
  • An easier way to have a pool saved queries that can opened quickly
Read full review
Usability
Amazon AWS
Easy to use. Scalable. Gets the job of data warehousing setup done. Using the datalake on S3 has become super convenient.
Read full review
JetBrains
Usability has two aspects, being a complete tool and being easy... DataGrip has a lot of features but it is big, not clear how to use most of the things and most people won't need them. In my opinion, usability is good enough but not friendly.
Read full review
Alternatives Considered
Amazon AWS
Read full review
JetBrains
DataGrip provides a single UI for many DBMS platforms, instead of using one for each. Because of that, you can migrate things between platforms using the tool and "look across" all databases at once.
Read full review
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.
Read full review
JetBrains
  • It has been perfect for detailed analysis of clients and companies; it gives us the competitiveness we were always looking for.
Read full review
ScreenShots