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

Amazon Redshift vs OpenText Analytics Database (Vertica) 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.9
Users report significant ROI from OpenText Analytics Database due to enhanced analytics, performance, and data accessibility, despite its cost.
Sentiment score
6.8
Snowflake users experience mixed ROI; challenges in calculation exist, but long-term benefits include cost reduction and improved data management.
 

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
7.0
OpenText Analytics Database customer service is praised for knowledgeable support, though some users report slow response and escalation needs.
Sentiment score
5.7
Snowflake's customer service is praised for expertise and helpfulness, though some note delays and lack of SLAs.
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 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
7.1
OpenText Analytics Database (Vertica) excels at scaling large data volumes but faces challenges with schema modifications and node additions.
Sentiment score
7.8
Snowflake is praised for scalability and efficiency, but concerns exist regarding cost-effectiveness in medium to large-scale organizations.
The scalability part needs improvement as the sizing requires trial and error.
Snowflake is very scalable and has a dedicated team constantly improving the product.
The billing doubles with size increase, but processing does not necessarily speed up accordingly.
 

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.1
OpenText Analytics Database (Vertica) is stable and robust, with minor query and network issues noted by users.
Sentiment score
8.2
Snowflake is praised for stability and reliability, with users noting excellent performance, quick issue resolution, and robust architecture.
Amazon Redshift is a stable product, and I would rate it nine or ten out of ten for stability.
Snowflake is very stable, especially when used with AWS.
Snowflake as a SaaS offering means that maintenance isn't an issue for me.
 

Room For Improvement

Amazon Redshift users struggle with data management, pricing, performance, integration, UI support, and compatibility with various data types.
OpenText Analytics Database needs better workload management, documentation, SQL optimization, cloud support, machine learning, and cost efficiency.
Snowflake users seek improved UI, pricing transparency, analytics, integrations, AI features, and enhanced support, ETL, and machine learning capabilities.
They should bring the entire ETL data management process into Amazon Redshift.
Integration with AI could be a good improvement.
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.
OpenText Analytics Database offers flexible pricing based on storage, with competitive costs, community edition, and negotiable licensing options.
Snowflake's pricing offers flexibility but can be unpredictable and expensive compared to Redshift or BigQuery, with room for transparency improvements.
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.
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.
OpenText Analytics Database offers rapid data processing, scalability, ease of use, and cost efficiency with advanced analytics capabilities.
Snowflake excels in scalable, secure data processing with fast queries, multi-format support, and seamless third-party integration for AI/ML.
Amazon Redshift's performance optimization and scalability are quite helpful, providing functionalities such as scaling up and down.
Scalability is also a strong point; I can scale it however I want without any limitations.
The specific features of Amazon Redshift that are beneficial for handling large data sets include fast retrieval due to cloud services and scalability, which allows us to retrieve data quickly.
Snowflake is a data lake on the cloud where all processing happens in memory, resulting in very fast query responses.
Being able to perform AI and Machine Learning in the same location as the data is quite advantageous.
 

Mindshare comparison

As of July 2025, in the Cloud Data Warehouse category, the mindshare of Amazon Redshift is 7.5%, down from 8.0% compared to the previous year. The mindshare of OpenText Analytics Database (Vertica) is 5.8%, up from 5.4% compared to the previous year. The mindshare of Snowflake is 18.2%, down from 23.2% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Cloud Data Warehouse
 

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.
T Venkatesh - PeerSpot reviewer
Processes query faster through multiple systems simultaneously, but it could support different data types
We use the solution for various tasks, including preparing data marts and generating offers. It helps extract data based on rules from the policy team and provides insights to enhance business operations. We also analyze transactions to target customers and improve business performance The…
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.
860,592 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Educational Organization
31%
Financial Services Firm
13%
Computer Software Company
11%
Manufacturing Company
6%
Financial Services Firm
19%
Computer Software Company
17%
Manufacturing Company
8%
Comms Service Provider
4%
Financial Services Firm
19%
Computer Software Company
12%
Educational Organization
10%
Manufacturing Company
7%
 

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 Vertica?
Vertica is easy to use and provides really high performance, stability, and scalability.
What is your experience regarding pricing and costs for Vertica?
The solution is relatively cost-effective. Pricing and licensing are reasonable compared to other solutions.
What needs improvement with Vertica?
The product could improve by adding support for a wider variety of data types and enhancing features to better compet...
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?
There is a need for a tool to help me estimate the cost of using Snowflake. Enhancements in user experience for data ...
 

Also Known As

No data available
Micro Focus Vertica, HPE Vertica, HPE Vertica on Demand
Snowflake Computing
 

Overview

 

Sample Customers

Liberty Mutual Insurance, 4Cite Marketing, BrandVerity, DNA Plc, Sirocco Systems, Gainsight, Blue 449
Cerner, Game Show Network Game, Guess by Marciano, Supercell, Etsy, Nascar, Empirix, adMarketplace, and Cardlytics.
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: June 2025.
860,592 professionals have used our research since 2012.