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."The solution is pretty simple to set up."
"The initial setup is pretty straightforward."
"The ability to resize the cluster is what really makes it stand out over other Hadoop and big data solutions."
"When we grade big jobs from on-prem to the cloud, we do it in EMR with Spark."
"The solution helps us manage huge volumes of data."
"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."
"Amazon EMR is a good solution that can be used to manage big data."
"The initial setup is straightforward."
"The best thing about Snowflake is its flexibility in changing warehouse sizes or computational power."
"Working with Parquet files is support out of the box and it makes large dataset processing much easier."
"I like the ability to work with a managed service on the cloud and that is easy to start with."
"The syntax is advanced which reduces the time to write code."
"The product's most important feature is unloading data to S3."
"The features that I have found most valuable are the ease of use, the rapidness, how quickly the solution can be implemented, and of course that it's been very easy to move from the on-premise world to the Cloud world because Snowflake is based on SQL also."
"Its speed and performance were the most valuable. Easy configuration of Snowflake in any cloud was also a benefit."
"The solution is very easy to use."
"The initial setup was time-consuming."
"We don't have much control. If we have multiple users, if they want to scale up, the cost will go and increase and we don't know how we can restrict that price part."
"There is no need to pay extra for third-party software."
"Amazon EMR is continuously improving, but maybe something like CI/CD out-of-the-box or integration with Prometheus Grafana."
"The problem for us is it starts very slow."
"The product must add some of the latest technologies to provide more flexibility to the users."
"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."
"The most complicated thing is configuring to the cluster and ensure it's running correctly."
"We would like to see more security including more masking and more encryption at the database level."
"For the Snowflake database, there should be some third-party features for the ETL. It would also be good to be able to use some kind of controls to get the data either from another database or a flat file. Its price should be improved. It should be cheaper than Microsoft."
"There are a lot of features that they need to come up with. A lot of functions are missing in Snowflake, so we have to find a workaround for those. For example, OUTER APPLY is a basic function in SQL Server, but it is not there in Snowflake. So, you have to write complex code for it."
"If they could bring in some tools for data integration, it would be really great."
"Snowflake has support for stored procedures, but it is not that powerful."
"It doesn't enforce typical relational database constraints. Quite expensive."
"Snowflake could improve migration. It should be made easier. It would be beneficial if it could offer some OLTP features. One of our customers was using Oracle for both data warehousing and OLTP workloads, and they were able to migrate their data warehousing workloads to Snowflake without major issues. However, for some of their OLTP requirements, such as needing a response time of fewer than 10 milliseconds for certain queries, Snowflake is currently unable to provide that."
"It's difficult to know how to size everything correctly."
Amazon EMR is ranked 9th in Cloud Data Warehouse with 20 reviews while Snowflake is ranked 1st in Cloud Data Warehouse with 92 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, Amazon Redshift, Azure Data Factory, Apache Spark and Microsoft Azure Synapse Analytics, whereas Snowflake is most compared with BigQuery, Azure Data Factory, Teradata, Vertica and Microsoft Azure Synapse Analytics. 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.