We changed our name from IT Central Station: Here's why

Amazon Redshift vs Snowflake comparison

Cancel
You must select at least 2 products to compare!
Amazon Redshift Logo
12,282 views|9,547 comparisons
Snowflake Logo
37,053 views|27,399 comparisons
Featured Review
Find out what your peers are saying about Amazon Redshift vs. Snowflake and other solutions. Updated: January 2022.
563,148 professionals have used our research since 2012.
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"Changing from local servers to the cloud is very easy. It's so nice not to have to worry about physical servers.""Has a very user-friendly SQL editor and it's very easy to use the connectors.""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 is very fast. It has really good response times. It's very user-friendly.""The processing of data is very fast.""I like the cost-benefit ratio, meaning that it is as easy to use as it is powerful and well-performing.""The most valuable feature is the scalability, as it grows according to our needs."

More Amazon Redshift Pros →

"Its performance is most valuable. As compared to SQL Server, we are able to see a significant improvement in performance with Snowflake.""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.""The most valuable feature is the snapshot database. In one second, you can just take a snapshot of the database for test purposes.""The features that I have found most valuable are the ease of use, the rapidness, how quickly the solution can be implemented, and of course that it's been very easy to move from the on-premise world to the Cloud world because Snowflake is based on SQL also.""We find the data sharing and data marketplace aspects of Snowflake absolutely amazing.""Working with Parquet files is support out of the box and it makes large dataset processing much easier.""I like the fact that we don't need a DBA. It automatically scales stuff.""The way it is built and designed is valuable. The way the shared model is built and the way it exploits the power of the cloud is very good. Certain features related to administration and management, akin to Oracle Flashback and all that, are very important for modern-day administration and management. It is also good in terms of managing and improving performance, indexing, and partitioning. It is sort of completely automated. Everything is essentially under the hood, and the engine takes care of it all. As a data warehouse on the cloud, Snowflake stands strong on its ground even though each of the cloud providers has its own data warehouse, such as Redshift for AWS or Synapse for Azure."

More Snowflake Pros →

Cons
"It would be useful to have an option where all of the data can be queried at once and then have the result shown.""Improvement could be made in the area of streaming data.""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.""There are too many limitations with respect to concurrency.""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.""Pricing is one of the things that it could improve. It should be more competitive.""In our experiments, the handling of unstructured data was not very smooth.""Amazon should provide more cloud-native tools that can integrate with Redshift like Microsoft's development tools for Azure."

More Amazon Redshift Cons →

"It would be better if they had a data profile tool that tells me where the gaps are in my time series data.""There are always a few operation updates here and there that can be made.""We would like to see more security including more masking and more encryption at the database level.""For the Snowflake database, there should be some third-party features for the ETL. It would also be good to be able to use some kind of controls to get the data either from another database or a flat file. Its price should be improved. It should be cheaper than Microsoft.""Pricing is an issue for many customers.""They need to improve its ETL functionality so that Snowflake becomes an ETL product. Snowpipe can do some pipelines and data ingestion, but as compare to Talend, these functionalities are limited. The ETL feature is not good enough. Therefore, Snowflake can only be used as a database. You can't use it as an ETL tool, which is a limitation. We have spoken to the vendor, and they said they are working on it, but I'm not sure when they will bring it to production.""There is a scope for improvement. They don't currently support integration with some of the Azure and AWS native services. It would be good if they can enhance their product to integrate with these services.""The documentation could improve. They should provide architecture information."

More Snowflake Cons →

Pricing and Cost Advice
  • "The part that I like best is that you only pay for what you are using."
  • "My customers have implementations that cost about $500 a month for a very small one. I also have a customer with a monthly invoice of about $25,000 USD."
  • "At the moment, pricing is a little bit on the higher side, although it depends on the size of the company."
  • "The price of the solution is reasonable. According to the RA3 cluster particularly, it provides 128 GB of storage with only four nodes. If you can manage your computations processes with the help of materialized views and proper queries. I think the IP clusters are very useful and overall fair for the price."
  • More Amazon Redshift Pricing and Cost Advice →

  • "It is not cheap."
  • "The pricing for Snowflake is competitive."
  • "On average, with the number of queries that we run, we pay approximately $200 USD per month."
  • "Pricing is approximately $US 50 per DB. Terabyte is around $US 50 per month."
  • "The price of Snowflake is very reasonable."
  • "The price of Snowflake is quite reasonable."
  • "Its price should be improved. It should be cheaper than Microsoft."
  • "It is per credit. It has a use-it-as-you-go model. We bought a chunk of 20,000 credits, and they were lasting us for at least a year. We didn't have the scale of data like a much larger company to consume more credits. For us, it was very inexpensive. Their strategy is just to leverage what you've got and put Snowflake in the middle. It doesn't make it expensive because most of the organizations already have reporting tools. Now, if you were starting from scratch, it might be cheaper to go a different way."
  • More Snowflake Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
    563,148 professionals have used our research since 2012.
    Questions from the Community
    Top Answer: 
    Amazon Redshift is very fast, has a very good response time, and is very user-friendly. The initial setup is very straightforward. This solution can merge and integrate well with many different… more »
    Top Answer: 
    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.
    Top Answer: 
    Once you have finished your designs they can be easily imported to Snowflake and the information can be readily accessed without an IT expert.
    Top Answer: 
    For our licensing, we renew every January by $25,000 in both credits. Their pricing structure is a pay-per-second usage in terms of credits, but you can get discounts if you buy them in bulk. I think… more »
    Top Answer: 
    The documentation could improve. They should provide architecture information. There could be better integration with tools other than the common databases used to receive data. There are other tools… more »
    Ranking
    4th
    Views
    12,282
    Comparisons
    9,547
    Reviews
    12
    Average Words per Review
    509
    Rating
    7.7
    1st
    Views
    37,053
    Comparisons
    27,399
    Reviews
    40
    Average Words per Review
    578
    Rating
    8.4
    Comparisons
    Also Known As
    Snowflake Computing
    Learn More
    Overview

    Amazon Redshift is a fast and powerful, fully managed, petabyte-scale data warehouse service in the cloud. Customers can start small for just $0.25 per hour with no commitments or upfront costs and scale to a petabyte or more for $1,000 per terabyte per year, less than a tenth of most other data warehousing solutions.

    Traditional data warehouses require significant time and resource to administer, especially for large datasets. In addition, the financial cost associated with building, maintaining, and growing self-managed, on-premise data warehouses is very high. Amazon Redshift not only significantly lowers the cost of a data warehouse, but also makes it easy to analyze large amounts of data very quickly.

    Amazon Redshift gives you fast querying capabilities over structured data using familiar SQL-based clients and business intelligence (BI) tools using standard ODBC and JDBC connections. Queries are distributed and parallelized across multiple physical resources. You can easily scale an Amazon Redshift data warehouse up or down with a few clicks in the AWS Management Console or with a single API call. Amazon Redshift automatically patches and backs up your data warehouse, storing the backups for a user-defined retention period. Amazon Redshift uses replication and continuous backups to enhance availability and improve data durability and can automatically recover from component and node failures. In addition, Amazon Redshift supports Amazon Virtual Private Cloud (Amazon VPC), SSL, AES-256 encryption and Hardware Security Modules (HSMs) to protect your data in transit and at rest.

    As with all Amazon Web Services, there are no up-front investments required, and you pay only for the resources you use. Amazon Redshift lets you pay as you go. You can even try Amazon Redshift for free.

    Snowflake provides a data warehouse built for the cloud, delivering a solution capable of solving problems for which legacy, on-premises and cloud data platforms were not designed.

    Offer
    Learn more about Amazon Redshift
    Learn more about Snowflake
    Sample Customers
    Liberty Mutual Insurance, 4Cite Marketing, BrandVerity, DNA Plc, Sirocco Systems, Gainsight, Blue 449
    Accordant Media, Adobe, Kixeye Inc., Revana, SOASTA, White Ops
    Top Industries
    REVIEWERS
    Comms Service Provider29%
    Retailer21%
    Logistics Company14%
    Computer Software Company14%
    VISITORS READING REVIEWS
    Computer Software Company29%
    Comms Service Provider13%
    Media Company11%
    Financial Services Firm8%
    REVIEWERS
    Computer Software Company39%
    Financial Services Firm11%
    Comms Service Provider7%
    Non Profit7%
    VISITORS READING REVIEWS
    Computer Software Company27%
    Comms Service Provider15%
    Financial Services Firm8%
    Insurance Company5%
    Company Size
    REVIEWERS
    Small Business31%
    Midsize Enterprise36%
    Large Enterprise33%
    REVIEWERS
    Small Business25%
    Midsize Enterprise27%
    Large Enterprise48%
    VISITORS READING REVIEWS
    Small Business16%
    Midsize Enterprise15%
    Large Enterprise68%
    Find out what your peers are saying about Amazon Redshift vs. Snowflake and other solutions. Updated: January 2022.
    563,148 professionals have used our research since 2012.

    Amazon Redshift is ranked 4th in Cloud Data Warehouse with 13 reviews while Snowflake is ranked 1st in Cloud Data Warehouse with 42 reviews. Amazon Redshift is rated 7.6, while Snowflake is rated 8.4. The top reviewer of Amazon Redshift writes "Scales according to our needs, which saves a lot in terms of upfront costs". 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 Microsoft Azure Synapse Analytics, Oracle Exadata, Vertica, Teradata and Oracle Autonomous Data Warehouse, whereas Snowflake is most compared with Microsoft Azure Synapse Analytics, Vertica, Teradata, Oracle Exadata and AWS Lake Formation. See our Amazon Redshift vs. Snowflake report.

    See our list of best Cloud 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.