AWS Glue vs. DataGrip

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
AWS Glue
Score 8.7 out of 10
N/A
AWS Glue is a managed extract, transform, and load (ETL) service designed to make it easy for customers to prepare and load data for analytics. With it, users can create and run an ETL job in the AWS Management Console. Users point AWS Glue to data stored on AWS, and AWS Glue discovers data and stores the associated metadata (e.g. table definition and schema) in the AWS Glue Data Catalog. Once cataloged, data is immediately searchable, queryable, and available for ETL.
$0.44
billed per second, 1 minute minimum
DataGrip
Score 9.6 out of 10
N/A
DataGrip, from JetBrains, is a database IDE that is tailored to suit the specific needs of professional SQL developers.
$99
per year per user
Pricing
AWS GlueDataGrip
Editions & Modules
per DPU-Hour
$0.44
billed per second, 1 minute minimum
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
AWS GlueDataGrip
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
Community Pulse
AWS GlueDataGrip
Considered Both Products
AWS Glue
Chose AWS Glue
Glue is easier especially if you are already in AWS. It easily integrates to other AWS services. Compliments well with Amazon Athena, S3, and Lake Formation. Compared to Snowflake, it is also much much cheaper and you don't have to build outside AWS. Support is also good if you …
Chose AWS Glue
Informatica Intelligent Cloud Integration Services and Informatica PowerCenter
Chose AWS Glue
AWS Glue is a fully managed ETL service that automates many ETL tasks, making it easier to set AWS Glue simplifies ETL through a visual interface and automated code generation.
Chose AWS Glue
AWS Glue is easier to use and has more and better features compared to it. And more documentation and tutorials and labs are widely available on the internet about AWS Glue which in turn helps in easier implementation of the spark jobs. Auto scaling is an added advantage. It's …
Chose AWS Glue
The main reason we choose AWS Glue over Talend open studio 1) Does not support Spark 2) Run only on java 3) not really feasible solution for heavy workloads 4) most of the cases need customer support 5) no proper documentation is available
Chose AWS Glue
AWS Glue is a managed service. It was easier for us to integrate it into our stack since we are already an AWS shop. It saved us the headache of managing a 3rd part service.
Chose AWS Glue
The cataloging of data objects is the best in the case of AWS Glue. We use AWS Glue in all of our data pipelines to sync external and internal data sources and to automatically produce SQL-based ETL based on AWS Glue catalog objects. Integration with Amazon products is the …
Chose AWS Glue
Glue comes in form of a managed service. However, the AWS data pipeline puts additional responsibility to manage the infrastructure. We were not requiring fine-grained control of the hardware which the AWS data pipeline provides. We also want to park our data on DynamoDB. AWS …
Chose AWS Glue
We are already in AWS services, so AWS glue is the first choice for us. But for the comparison of ETL job making and process time, it's way faster for other services.
DataGrip
Chose DataGrip
I think it blows away mysql workbench hands down. Workbench does have more functionality when it comes managing the mysql instance, viewing performance etc. Navicat is ok, it might be better for new database develoopers. I stumbled upon DataGrip cause it came with jetbrains …
Chose DataGrip
One place for all the connections and uniformity of use and interaction
Chose DataGrip
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.
Chose DataGrip
DataGrip is the most widely used software for simplified data management; we can know what is missing and what is leftover. The interface is straightforward and with a lot of security in its use of the system. All this has been its plus point.
Chose DataGrip
DataGrip makes it easy to access and manage multiple databases locally and remotely, simplifies everything, and has powerful integrated features and resources that allow you to visualize and analyze data from a single platform.
Best Alternatives
AWS GlueDataGrip
Small Businesses
IBM SPSS Modeler
IBM SPSS Modeler
Score 9.4 out of 10
PyCharm
PyCharm
Score 9.2 out of 10
Medium-sized Companies
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.0 out of 10
PyCharm
PyCharm
Score 9.2 out of 10
Enterprises
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.0 out of 10
PyCharm
PyCharm
Score 9.2 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
AWS GlueDataGrip
Likelihood to Recommend
9.0
(0 ratings)
8.4
(0 ratings)
Usability
9.4
(0 ratings)
8.5
(0 ratings)
Support Rating
7.0
(0 ratings)
-
(0 ratings)
User Testimonials
AWS GlueDataGrip
Likelihood to Recommend
When the data which requires ETL has different formats, schema, and volume, this service suits them best. So, when the volume is not consistent (typical use-case of healthcare and online shopping), AWS Glue can be the prime choice. When the data is available in both batch and streaming mode, the developer needs to generate a separate codebase. This increases the source code management efforts. So, prefer to go with Glue when the nature of the data is the same (either batched or streamed).
Read full review
It is undoubtedly one of the best database management programs. It dramatically simplifies database management and administration. Its extensive support for various database engines is a point to highlight when we talk about DataGrip; you will like having such a powerful resource much as we do.
Read full review
Pros
  • After data cleansing, the team also implemented the best practices for using AWS platform services as a Data Lake, such as job bookmarking for AWS Glue jobs, proper delimiter for the AWS Glue crawlers, partitioning in AWS S3, and transformation to parquet file for compression and faster querying time in Amazon Athena.
  • Data modernization through combining data from multiple sources into a functioning datasets, rebuilding DW, and resctructuring data sources.
  • Aims to lessen customer complaints, eliminate manual data extraction requests via SR from different data sources, and Increase accuracy, consistency and speed up reconciliation process.
Read full review
  • Connects to most of the db engines known
  • auto complete is powerful and db objects introspection is complete
  • one place for all your db connections
Read full review
Cons
  • It’s integration with other cloud vendors is bit difficult
  • If it can support non SQL based databases as well, it would be powerful.
  • Real time data synchronisation in data source is missing
Read full review
  • Can be a memory hog
  • No free community version with limited functionality
Read full review
Usability
I personally found it very usable for a data engineer's day job, particularly for performing ETL and managing the data pipelines.
Read full review
Perfect other than a way to handle saving and re-using queries. A simple/better way of creating a pool of queries for each project or database connection would be very helpful. It is not bad now, just could be a better. I have used Navicat for MySQL in the past it had that feature. It could save all your queries to the cloud and you could use them on any device.
Read full review
Support Rating
Amazon responds in good time once the ticket has been generated but needs to generate tickets frequent because very few sample codes are available, and it's not cover all the scenarios.
Read full review
No answers on this topic
Alternatives Considered
The cataloging of data objects is the best in the case of AWS Glue. We use AWS Glue in all of our data pipelines to sync external and internal data sources and to automatically produce SQL-based ETL based on AWS Glue catalog objects. Integration with Amazon products is the other advantage.
Read full review
DataGrip is the most widely used software for simplified data management; we can know what is missing and what is leftover. The interface is straightforward and with a lot of security in its use of the system. All this has been its plus point.
Read full review
Return on Investment
  • Positive Impact :- after ETL we can able to do some kind of automation
  • Negative :- At some point of time it can hamper the cost but not really
Read full review
  • Less time to develop database structures
  • Easy to filter and find data
  • Export data for reporting purposes
Read full review
ScreenShots