We performed a comparison between Amazon Redshift 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 most valuable feature of Amazon Redshift is its ability to handle really large sets of data."
"This service can merge and integrate well with all databases."
"Redshift's Excel features are handy. Redshift spectrum allows you to directly query the data on an Excel sheet. Now, SQL Server also allows this, but Redshift has many more features."
"Amazon Redshift offers a relatively flexible structure...I rate the technical support a nine out of ten."
"The solution has very competitive pricing."
"It is quite simple to use and there are no issues with creating the tables."
"You can copy JSON to the column and have it analyzed using simple functions."
"For the on-premises version of Amazon Redshift, we need to start from scratch. However, with the cloud version whenever you want to deploy, you can scale up, and down, and it has a data warehousing capability. Redshift has many features."
"The ETL and data ingestion capabilities are better in this solution as compared to SQL Server. SQL Server doesn't do much data ingestion, but Snowflake can do it quite conveniently."
"It helped us to build MVP (minimum viable product) for our idea of building a data warehouse model for small businesses."
"This solution has helped our organization by being easy to maintain and having good technical support."
"The most valuable feature of Snowflake is its performance. We can access the data quickly. Additionally, it handles structured and non-structured data."
"Snowflake has three great features: Snowpiping is proving to be very valuable, Time Travel is excellent, and Snowpipes are another great functionality the solution has made available."
"Its speed and performance were the most valuable. Easy configuration of Snowflake in any cloud was also a benefit."
"The overall ecosystem was easy to manage. Given that we weren't a very highly technical group, it was preferable to other things we looked at because it could do all of the cloud tunings. It can tune your data warehouse to an appropriate size for controlled billing, resume and sleep functions, and all such things. It was much more simple than doing native Azure or AWS development. It was stable, and their support was also perfect. It was also very easy to deploy. It was one of those rare times where they did exactly what they said they could do."
"The most efficient way for real-time dashboards or analytical business intelligence reports to be sent to the customer."
"There is some missing functionality and sometimes it's so difficult to work in. We need to convert these functionalities using VACUUM inside Amazon Redshift and then it causes some complexity."
"Amazon Redshift is a little more expensive than other products."
"Compatibility with other products, for example, Microsoft and Google, is a bit difficult because each one of them wants to be isolated with their solutions."
"If you require a highly scalable solution, I would not recommend Amazon Redshift."
"One area where Amazon Redshift could improve is in adopting the compute-separate, data-separate architecture, which Delta, Snowflake are adopting, and a few others in the cloud data warehouse spectrum."
"It lacks a few features which can be very useful, such as stored procedures"
"Migrating data from other data sources can be challenging when you are working with multibyte character sets."
"The product must become a bit more serverless."
"From the documentation, the black box is not very descriptive. Snowflake does not reveal how exactly the data is processed or sourced."
"The UI could improve because sometimes in the security query the UI freezes. We then have to close the window and restart."
"I am still in the learning stage. It has good security, but it can always be more secure."
"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."
"Product activation queries can't be changed while executing."
"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."
"Their UiPath, the workspace area, needs some work."
"If we can have a feature where the results can be moved to different tabs, so that I can compare the results with earlier queries before applying the changes, it would be great."
Amazon Redshift is ranked 4th in Cloud Data Warehouse with 58 reviews while Snowflake is ranked 1st in Cloud Data Warehouse with 92 reviews. Amazon Redshift is rated 7.8, while Snowflake is rated 8.4. The top reviewer of Amazon Redshift writes "Provides one place where we can store data, and allows us to easily connect to other services with AWS". 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 Redshift is most compared with AWS Lake Formation, Teradata, Vertica, Microsoft Azure Synapse Analytics and Oracle Exadata, whereas Snowflake is most compared with BigQuery, Azure Data Factory, Teradata, Vertica and Matillion ETL. See our Amazon Redshift vs. Snowflake report.
See our list of best Cloud Data Warehouse vendors and best 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.
Although I verified it only in a specific case, I performed performance verification with Redshift, BigQuery, Snowflake.
Redshift has data redistribution occurred when searching under various conditions and performance was not good, but Snowflake holds data in small units called micro partitions, and also manages data for each column Therefore, operation like data redistribution was minimal and high performance was obtained.
Snowflake can also start multiple clusters in the same database, but has an architecture in which conflicts do not occur even when accessing the same data between clusters.
I recommend you to try it.
I am glad that you are already using it.