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."One of the valuable features about this solution is that it's managed services, so it's pretty stable, and scalable as much as you wish. It has all the necessary distributions. With some additional work, it's also possible to change to a Spark version with the latest version of EMR. It also has Hudi, so we are leveraging Apache Hudi on EMR for change data capture, so then it comes out-of-the-box in EMR."
"The solution is pretty simple to set up."
"When we grade big jobs from on-prem to the cloud, we do it in EMR with Spark."
"The solution is scalable."
"The solution helps us manage huge volumes of data."
"Amazon EMR's most valuable features are processing speed and data storage capacity."
"It allows users to access the data through a web interface."
"The initial setup is straightforward."
"I like the idea that you can assign roles and responsibilities, limiting access to data."
"The most efficient way for real-time dashboards or analytical business intelligence reports to be sent to the customer."
"I like the fact that we don't need a DBA. It automatically scales stuff."
"The querying speed is fast."
"I like the ability to work with a managed service on the cloud and that is easy to start with."
"The technical support is pretty good, particularly if you are a more technical user."
"The solution is easy to use."
"Snowflake is a database, and it is very good and useful. The most interesting part is that memory management is very good in Snowflake. For a business intelligence project, SQL Server is taking a lot of time for reporting services. There are a lot of calculations, and the reporting time is shown as two minutes, whereas Snowflake is taking just two seconds for the same reporting services."
"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 is continuously improving, but maybe something like CI/CD out-of-the-box or integration with Prometheus Grafana."
"The initial setup was time-consuming."
"The problem for us is it starts very slow."
"There is no need to pay extra for third-party software."
"The legacy versions of the solution are not supported in the new versions."
"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."
"The most complicated thing is configuring to the cluster and ensure it's running correctly."
"Snowflake has to build more capabilities because they have only built very few adapters, but they're growing and they're building. They should provide provisions to collect ETL pipeline capabilities, reduce developer work, and make more rapid application development, rather than some customizations. There are very few options, but they are building. I hope they will build ETL rapid application development provisions with more variety."
"Maybe there could be some more connectors to other systems, but this is what they are constantly developing anyway."
"They don't have any SLAs in place. It would be better if they did."
"The solution should offer an on-premises version also. We have some requirements where we would prefer to use it as a template."
"Getting data out of the tool to third-party applications is difficult."
"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."
"I have heard people having difficulty with the machine learning model, so there may be room for improvement."
"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."
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.