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."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."
"The most valuable feature is that the solution is fully embedded in the AWS stack."
"Though Amazon Redshift is good, it depends on what kind of business you're trying to do, what type of analytics you need, and how much data you have."
"The most valuable feature is its scalability."
"The initial setup of this solution is straightforward."
"Amazon Redshift offers a relatively flexible structure...I rate the technical support a nine out of ten."
"I found the Amazon Redshift computing services easy. I found the computing instances the most incredible in the solution."
"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."
"The most valuable feature of Snowflake is it's an all-in-one data warehousing solution."
"I like the fact that we don't need a DBA. It automatically scales stuff."
"The pricing is reasonable and matches the rest of the market."
"It is a highly scalable solution. There is no limit on storage or computing."
"We find the data sharing and data marketplace aspects of Snowflake absolutely amazing."
"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."
"The adaptation to development languages is most valuable. Our developers can SQL code or something else. It has been convenient in that regard."
"The most valuable feature of Snowflake is its performance. We can access the data quickly. Additionally, it handles structured and non-structured data."
"The refreshment rate of data reaching Redshift from other sources should be faster."
"If you require a highly scalable solution, I would not recommend Amazon Redshift."
"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."
"Amazon Redshift does not have the capability to dynamically increase the VM file."
"The customer support could be more responsive."
"The product could be improved by making it more flexible."
"Should be made available across zones, like other Multi-AZ solutions."
"Query compilation time needs a lot of improvement for cases where you are generating queries dynamically."
"Its stability could be better."
"It would be better if they had a data profile tool that tells me where the gaps are in my time series data."
"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."
"From the documentation, the black box is not very descriptive. Snowflake does not reveal how exactly the data is processed or sourced."
"There is room for improvement in Snowflake's integration with Python. We do a lot of SQL programming in Snowflake, but we go to a different tool to program when we have to in Python."
"The solution could use a little bit more UI."
"It needs a bit more rigor and governance, which is something you don't get with newer tools. This makes it less enterprise scalable. Its governance and structure can be enhanced, which would really be valuable. I would like to see some kind of prebuilt functionality in terms of having almost like a pre-built data warehouse. A functionality for generating automated kind of pieces would be good."
"There could be better ELT tools that are appropriate for Snowflake. We decided on Matillion and it seemed to be the only one. There need to be better choices, it would be great if Snowflake provided an ELT solution that people could use. Additionally, if there was a pure cloud-based ELT tool it would be useful."
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.