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."In terms of valuable features, I like the columnar storage that Redshift provides. The storage is one of the key features that we're looking for. Also, the data updates and the latency between the data-refreshes."
"The most valuable feature is the scalability, as it grows according to our needs."
"The product is relatively easy to use because there is no indexing and no partitions."
"Has a very user-friendly SQL editor and it's very easy to use the connectors."
"The most valuable features of Amazon Redshift are that its fast and efficient. We have lots of TBs of data and it's very fast."
"The stability of Amazon Redshift is good."
"I find the most valuable features to be the MPP style of processing, which mostly all of the data warehouses provide. The ability to integrate all other AWS services, such as NSS and S3, with little effort is very helpful. The service is well maintained, there are update patches frequently."
"Setup is easy. It's a fast solution with machine learning features, good integration, and a good API."
"The most valuable feature of Snowflake is its performance. We can access the data quickly. Additionally, it handles structured and non-structured data."
"The solution is very stable."
"The technical support is pretty good, particularly if you are a more technical user."
"Its performance is most valuable. As compared to SQL Server, we are able to see a significant improvement in performance with Snowflake."
"The product's most important feature is unloading data to S3."
"The most efficient way for real-time dashboards or analytical business intelligence reports to be sent to the customer."
"The Mbps they have established is quite a bit faster than any other data warehouse."
"It is a very easy-to-use solution. It is user-friendly, and its setup time is very less."
"Running parallel queries results in poor performance and this needs to be improved."
"There are too many limitations with respect to concurrency."
"The solution has four maintenance windows so, when it comes to stability, I think it would be better to decrease their number."
"Planting is the primary key enforcement that should be improved."
"We recently moved from the DC2 cluster to the RA3 cluster, which is a different node type and we are finding some issues with the RA3 cluster regarding connection and processing. There is room for improvement in this area. We are in talks with AWS regarding the connection issues."
"If you require a highly scalable solution, I would not recommend Amazon Redshift."
"The speed of the solution and its portability needs improvement."
"We are using third-party tools to integrate Amazon Redshift, they should create their own interface on their own for it to be easily connected on the AWS itself."
"Their strategy is just to leverage what you've got and put Snowflake in the middle. It does work well with other tools. You have to buy a separate reporting tool and a separate data loading tool, whereas, in some platforms, these tools are baked in. In the long-term, they'll need to add more direct partnerships to the ecosystem so that it's not like adding on tools around Snowflake to make it work. They can also consider including Snowflake native reporting tools versus partnering with other reporting tools. It would kind of change where they sit in the market."
"I have heard people having difficulty with the machine learning model, so there may be room for improvement."
"Its stability could be better."
"This solution could be improved by offering machine learning apps."
"There are always a few operation updates here and there that can be made."
"An additional feature I'd like to see is called materialized views, which can speed up some run times. I'd like it to be able to be used where you can have multiple tables inside them; materialized view. That would be nice. As well as being able to run cursors, to be able to do some bulk updates and some more advanced querying, table building on the fly."
"They should improve the reporting tools."
"The solution could use a little bit more UI."
Amazon Redshift is ranked 4th in Cloud Data Warehouse with 57 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, Microsoft Azure Synapse Analytics, Vertica, Teradata 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.