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."Redshift's versioning and data security are the two most critical features. When migrating into the cloud, it's vital to secure the data. The encryption and security are there."
"The product offers good support for the data lake."
"The feature that we find most useful is the ability to do analytics on the fly."
"I like it because the usage is very similar to Microsoft SQL server. The structure of the query and the temporary tables are very similar."
"Amazon Redshift offers a relatively flexible structure...I rate the technical support a nine out of ten."
"I like the cost-benefit ratio, meaning that it is as easy to use as it is powerful and well-performing."
"Setup is easy. It's a fast solution with machine learning features, good integration, and a good API."
"Amazon Redshift is very fast. It has really good response times. It's very user-friendly."
"It's ultra-fast at handling queries, which is what we find very convenient."
"Snowflake is an enormously useful platform. The Snowpipe feature is valuable because it allows us to load terabytes and petabytes of data into the data mart at a very low cost."
"It is a very well-distributed system. It has different data engines for different applications. Many applications can use different computational engines at the same time. In terms of data processing, the feeling was similar to working with a relational database but in a scalable way."
"It is a very easy-to-use solution. It is user-friendly, and its setup time is very less."
"Once you have finished your designs they can be easily imported to Snowflake and the information can be readily accessed without an IT expert."
"The solution's computing time is less."
"My company wanted to have all our data in one single place and this what we use Snowflake for. Snowflake also allows us to build connectors to different data sources."
"The syntax is advanced which reduces the time to write code."
"The speed of the solution and its portability needs improvement."
"This solution lacks integration with non-AWS sources."
"Planting is the primary key enforcement that should be improved."
"It would be nice if we could turn off an instance. However, it would retain the instance in history, thus allowing us to restart without beginning from scratch."
"Sometimes, it's difficult to get the metadata from Redshift."
"Infinite storage is available in Snowflake and is not available in Redshift."
"It would be useful to have an option where all of the data can be queried at once and then have the result shown."
"The solution could improve in handling more data formats and more native support for RDF."
"I have heard people having difficulty with the machine learning model, so there may be room for improvement."
"Availability is a problem."
"In a future release we would like to have a link which would allow us to connect to an external database and create certain views in your own database. This is because it is becoming hard for us to compare the data between multiple sources."
"Room for improvement would be writebacks. It doesn't support extensively writing back to the database, and it doesn't support web applications effectively. Ultimately, it's a database call, so if we are building web applications using Snowflake, it isn't that effective because there is some turnaround time from the database."
"The price could be improved."
"The cost is a bit high."
"It's not that flexible when compared to Oracle."
"Maybe there could be some more connectors to other systems, but this is what they are constantly developing anyway."
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.