Try our new research platform with insights from 80,000+ expert users

Amazon Redshift vs Oracle Database Appliance vs Snowflake comparison

 

Comparison Buyer's Guide

Executive Summary

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

ROI

Sentiment score
6.2
Amazon Redshift ROI varies; cloud transition boosts sales but data volume impacts cost-effectiveness compared to databases like Netezza.
Sentiment score
6.1
Oracle Database Appliance provides strong ROI through efficient deployment, quality support, and long-term value, despite higher initial costs.
Sentiment score
6.8
Snowflake users praise its scalability and ease of use, though financial gains vary and may require longer usage periods.
 

Customer Service

Sentiment score
6.9
Amazon Redshift's customer service is praised for efficiency and professionalism, though some desire easier phone access and consistent availability.
Sentiment score
6.3
Users appreciate Oracle Database Appliance's support for expertise and responsiveness, but report issues with response time and costs.
Sentiment score
5.7
Snowflake support is responsive and helpful, with high user satisfaction, despite occasional slower response times and ticketing reliance.
Whenever we need support, if there is an issue accessing stored data due to regional data center problems, the Amazon team is very helpful and provides optimal solutions quickly.
It's costly when you enable support.
I would rate Oracle support nine or ten out of ten because you can always open a ticket and describe any problems, and the feedback is very quick.
I received great support in migrating data to Snowflake, with quick responses and innovative solutions.
The technical support from Snowflake is very good, nice, and efficient.
 

Scalability Issues

Sentiment score
7.4
Redshift is popular for its easy scalability on AWS, although some users face challenges with large cluster configurations.
Sentiment score
6.4
Oracle Database Appliance is scalable and well-suited for small to medium setups, but has mixed reviews for larger enterprises.
Sentiment score
7.8
Snowflake offers excellent scalability, adaptable to varying needs, with minimal challenges but requires cost and resource management attention.
The scalability part needs improvement as the sizing requires trial and error.
All enterprise-grade analytics tools allow rapid scaling, making our business more competitive.
The billing doubles with size increase, but processing does not necessarily speed up accordingly.
Snowflake is very scalable and has a dedicated team constantly improving the product.
 

Stability Issues

Sentiment score
7.4
Amazon Redshift is stable with minor scaling challenges, appreciated AWS support, and noted visibility concerns versus Snowflake.
Sentiment score
7.5
Oracle Database Appliance is stable, with minor setup issues, improved reliability in recent versions, and scalability limitations.
Sentiment score
8.2
Snowflake offers high stability and reliability with minimal downtime, rapid recovery, and seamless failover across platforms, especially AWS.
Amazon Redshift is a stable product, and I would rate it nine or ten out of ten for stability.
Snowflake as a SaaS offering means that maintenance isn't an issue for me.
Snowflake is very stable, especially when used with AWS.
 

Room For Improvement

Amazon Redshift users struggle with data management, pricing, performance, integration, UI support, and compatibility with various data types.
Oracle Database Appliance needs faster implementation, scalability improvements, unified admin commands, better support, and increased affordability and integration.
Snowflake needs interface improvements, better ETL, machine learning features, pricing clarity, advanced tools, and enhanced documentation and security.
Integration with AI could be a good improvement.
They should bring the entire ETL data management process into Amazon Redshift.
There is room for improvement in better integration with third-party tools, such as Power BI or Redshift.
For the cloud version, there could be better storage options or more storage for lower prices.
Enhancements in user experience for data observability and quality checks would be beneficial, as these tasks currently require SQL coding, which might be challenging for some users.
Cost reduction is one area I would like Snowflake to improve.
 

Setup Cost

Amazon Redshift offers competitive pricing with scalable costs, ideal for large enterprises, though not as economical for smaller companies.
Enterprise buyers find Oracle Database Appliance costly, but its stability, fast implementation, and included support justify the price.
Snowflake offers competitive pay-as-you-go pricing with some concerns over transparency, predictability, and potential cost escalation.
It's a pretty good price and reasonable for the product quality.
The cost of technical support is high.
The pricing of Amazon Redshift is expensive.
Oracle is on the higher end of the pricing spectrum, along with SAP.
Snowflake's pricing is on the higher side.
Snowflake lacks transparency in estimating resource usage.
 

Valuable Features

Amazon Redshift offers scalable, efficient, and secure data warehousing with fast processing, AWS integration, and flexible configurations for analytics.
Oracle Database Appliance ensures easy deployment, scalability, and high performance with seamless Oracle Cloud integration and flexible licensing.
Snowflake excels in scalability, efficiency, ease of use, AI/ML capabilities, security, and seamless third-party integration, enhancing user experience.
Amazon Redshift's performance optimization and scalability are quite helpful, providing functionalities such as scaling up and down.
Scalability is the best feature of Amazon Redshift. Amazon Redshift handles scalability automatically, so we do not need to scale up or down; it is all managed by Redshift.
Scalability is also a strong point; I can scale it however I want without any limitations.
The most valuable feature is the ease of dashboarding and ease of reporting.
The automated provisioning feature helps speed up the database deployment process because you can use one command or option to resize all the disks or increase memory, depending on the occasion.
One key feature is the separation of compute and storage, which eliminates storage limitations.
The scalability options it provides, addressing issues without tying workloads into one virtual machine, enhance functionality.
 

Featured Reviews

Sriram-Natesan - PeerSpot reviewer
The ability to create a lot of views or materialized views is beneficial
Improvement in the immediate response and the process of getting into a call could be helpful. We have had to wait for at least twenty-four hours to get a call and then wait for a couple more hours for a solution. Improved connectivity to different BI tools and already published connectors for major tools in AWS could enhance the service.
Rubens Oliveira - PeerSpot reviewer
Automated provisioning simplifies deployment and integration
The Oracle Database Appliance is customizable and has excellent features.I don't have any problems with Oracle Database Appliance because this product is very automated, with scheduler and automatic processes throughout. You can make small inferences and changes for creating all the specific modifications. The automated provisioning feature helps speed up the database deployment process because you can use one command or option to resize all the disks or increase memory, depending on the occasion. The Oracle Database Appliance has integration in OCI Cloud. The same services simplify all the manager work regarding backups, configuration, resizing disks, and other services. Deploying the Oracle Database Appliance both on-premises and in the cloud offers the same simplification. You simply input your database name and specify memory quantity, CPU quantity, and database size. The process is identical for both on-premises and cloud deployments. The flexibility of Oracle Database Appliance has helped grow business needs for many customers. Using the Oracle Database Appliance has positively impacted my organization because I can deliver it much more comfortably. Creating a database involves many processes, but with this solution, you just input the name and configure the network and other parameters. It is very similar to RDS in AWS services, where you specify the name, choose the engine, indicate parameter groups, VPC, subnet groups, and proceed. Both Oracle Database Appliance and RDS have greatly simplified the work.
Snehasish Das - PeerSpot reviewer
Transformation in data querying speed with good migration capabilities
Snowflake is a data lake on the cloud where all processing happens in memory, resulting in very fast query responses. One key feature is the separation of compute and storage, which eliminates storage limitations. It also has tools for migrating data from legacy databases like Oracle. Its stability and efficiency enhance performance greatly. Tools in the AI/ML marketplace are readily available without needing development.
report
Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
865,649 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
18%
Computer Software Company
14%
Manufacturing Company
10%
Government
8%
Financial Services Firm
25%
Computer Software Company
11%
Manufacturing Company
7%
Government
7%
Financial Services Firm
20%
Computer Software Company
12%
Manufacturing Company
8%
Healthcare Company
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

How does Amazon Redshift compare with Microsoft Azure Synapse Analytics?
Amazon Redshift is very fast, has a very good response time, and is very user-friendly. The initial setup is very str...
What do you like most about Amazon Redshift?
The tool's most valuable feature is its parallel processing capability. It can handle massive amounts of data, even w...
What do you like most about Oracle Database Appliance?
Oracle Database Appliance provides high stability.
What is your experience regarding pricing and costs for Oracle Database Appliance?
While I'm somewhat familiar with standard licensing, pricing isn't really my area of expertise. However, Oracle is on...
What needs improvement with Oracle Database Appliance?
For the cloud version, there could be better storage options or more storage for lower prices. However, for on-premis...
What do you like most about Snowflake?
The best thing about Snowflake is its flexibility in changing warehouse sizes or computational power.
What is your experience regarding pricing and costs for Snowflake?
It is complicated to understand how requests impact warehouse size. Unlike competitors such as Microsoft and Databric...
What needs improvement with Snowflake?
Pricing is quite high for Snowflake Data Cloud, which is an area that could be improved. Snowflake Data Cloud is stil...
 

Also Known As

No data available
X5-2
Snowflake Computing, Snowflake Data Cloud
 

Overview

 

Sample Customers

Liberty Mutual Insurance, 4Cite Marketing, BrandVerity, DNA Plc, Sirocco Systems, Gainsight, Blue 449
LifeLock, Incarlopsa, Al Yusur Industrial Contracting
Accordant Media, Adobe, Kixeye Inc., Revana, SOASTA, White Ops
Find out what your peers are saying about Snowflake Computing, Microsoft, Google and others in Cloud Data Warehouse. Updated: July 2025.
865,649 professionals have used our research since 2012.