We performed a comparison between Amazon EMR and Snowflake based on real PeerSpot user reviews.
Find out in this report how the two Cloud Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."When we grade big jobs from on-prem to the cloud, we do it in EMR with Spark."
"Amazon EMR's most valuable features are processing speed and data storage capacity."
"The project management is very streamlined."
"It allows users to access the data through a web interface."
"The initial setup is pretty straightforward."
"We are using applications, such as Splunk, Livy, Hadoop, and Spark. We are using all of these applications in Amazon EMR and they're helping us a lot."
"It has a variety of options and support systems."
"Amazon EMR is a good solution that can be used to manage big data."
"The pricing is reasonable and matches the rest of the market."
"It was relatively easy to use, and it was easy for people to convert to it."
"Great scalability and near zero maintenance."
"The solution speeds up the process of onboarding."
"This is the advanced version of the cloud version, so it's really a flexible tool. If you have it implemented at home, you can access it from anywhere."
"Time travel is one feature that really helps us out."
"I like the ability to work with a managed service on the cloud and that is easy to start with."
"The solution is easy to use."
"There is no need to pay extra for third-party software."
"The most complicated thing is configuring to the cluster and ensure it's running correctly."
"There were times where they would release new versions and it seemed to end up breaking old versions, which is very strange."
"The legacy versions of the solution are not supported in the new versions."
"The problem for us is it starts very slow."
"The dashboard management could be better. Right now, it's lacking a bit."
"As people are shifting from legacy solutions to other technologies, Amazon EMR needs to add more features that give more flexibility in managing user data."
"Amazon EMR can improve by adding some features, such as megastore services and HiveServer2. Additionally, the user interface could be better, similar to what Apache service provides, cross-platform services."
"Support needs improvement, as it can take several days before you get some initial support."
"The solution should offer an on-premises version also. We have some requirements where we would prefer to use it as a template."
"We would like to have an on-premises deployment option that has the same features, including scalability."
"They have a new console, but I couldn't figure out anything in the new console. So, if I shift to the old console, I can figure out where to create the database schema and other things, but I have no idea where to go in the new console. That's one thing they can improve. I don't know why they created a new console to confuse. The old, classic console is much better."
"It would benefit from an administration that allows you to be aware of your credit consumption once you have the service so that you may be sure how many credits you are consuming when you use the platform and to make sure that you are making the most efficient use of these resources. In other words, to improve their interface so that you may monitor the consumption of your credits on Cloud."
"They need to incorporate some basic OLAP capabilities in the backend or at the database level. Currently, it is purely a database. They call it purely a data warehouse for the cloud. Currently, just like any database, we have to calculate all the KPIs in the front-end tools. The same KPIs again need to be calculated in Snowflake. It would be very helpful if they can include some OLAP features. This will bring efficiency because we will be able to create the KPIs within Snowflake itself and then publish them to multiple front-end tools. We won't have to recreate the same in each project. There should be the ability to automate raised queries, which is currently not possible. There should also be something for Exception Aggregation and things like that."
"I don't know about GCP, if they have connected for GCP. If they don't, they should allow for it."
"There are some challenges with loading unstructured data and integrating some message queues or brokers. In one project, we had a problem connecting to one of the message queues and we had to take a different route altogether on Microsoft Azure."
Amazon EMR is ranked 8th in Cloud Data Warehouse with 20 reviews while Snowflake is ranked 1st in Cloud Data Warehouse with 94 reviews. Amazon EMR is rated 7.8, while Snowflake is rated 8.4. The top reviewer of Amazon EMR writes "Provides efficient data processing features and has good scalability ". On the other hand, the top reviewer of Snowflake writes "Good usability, good data sharing and elastic compute features, and requires less DBA involvement". Amazon EMR is most compared with Cloudera Distribution for Hadoop, Azure Data Factory, Amazon Redshift, Apache Spark and Microsoft Azure Synapse Analytics, whereas Snowflake is most compared with BigQuery, Azure Data Factory, Teradata, Vertica and SAP BW4HANA. See our Amazon EMR vs. Snowflake report.
See our list of best Cloud Data Warehouse vendors.
We monitor all Cloud Data Warehouse reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.