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 main benefit is that our portal for end users is running in AWS, so we can easily connect it to other AWS services."
"Amazon Redshift offers a relatively flexible structure...I rate the technical support a nine out of ten."
"The initial setup is easy."
"It's scalable because it's on the cloud."
"Redshift has an advantage when it comes to administration, making it easier to manage and collaborate."
"Redshift allows you to transform different data formats and consolidate them into one Redshift cluster. This means you can transform various siloed data sources like Excel files and CSV files into Redshift."
"Redshift Spectrum is the most valuable feature."
"It is very easy to dump data into the tool."
"It was relatively easy to use, and it was easy for people to convert to it."
"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."
"It has great flexibility whenever we are loading data and performs ELT (extract, load, transform) techniques instead of ETL."
"The most valuable features of Snowflake are that you have to pay per usage, and you don't have to worry about the maintenance of the data warehouse because it is on the cloud."
"Its speed and performance were the most valuable. Easy configuration of Snowflake in any cloud was also a benefit."
"The feature that is really striking is the ability to translate the SQL workloads into the NoSQL version that can be used by Snowflake."
"It is quite easy to manage."
"Time travel is one feature that really helps us out."
"Pricing is one of the things that it could improve. It should be more competitive."
"The product could be improved by making it more flexible."
"In the solution, user-based access is quite hard. In general, certain permissions are difficult to manage."
"There are too many limitations with respect to concurrency."
"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."
"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."
"What would make Amazon Redshift better is improvising on the pricing structure. For example, Acronis provides backups in cybersecurity, yet the pricing is a bit lesser than Amazon Redshift."
"I would like to improve the pricing and the simplicity of using this solution."
"I see room for improvement when it comes to credit performance. The other thing I'd like to be improved is the warehouse facility."
"It's not that flexible when compared to Oracle."
"Snowflake could improve if they had an Operational Data Store(ODS) space."
"I don't know about GCP, if they have connected for GCP. If they don't, they should allow for it."
"I would like to see more transparency in data processing, ATLs, and compute areas - which should give more comfort to the end users."
"The solution could improve the user interface and add functionality to the system."
"Snowflake can improve its machine learning and AI capabilities."
"It would be better if they had a data profile tool that tells me where the gaps are in my time series data."
Amazon Redshift is ranked 4th in Cloud Data Warehouse with 61 reviews while Snowflake is ranked 1st in Cloud Data Warehouse with 94 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 Teradata, Vertica, Microsoft Azure Synapse Analytics, AWS Lake Formation and Oracle Exadata, whereas Snowflake is most compared with BigQuery, Azure Data Factory, Teradata, Vertica and Apache Hadoop. 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.