Amazon Redshift vs Teradata Cloud Data Warehouse comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

Amazon Redshift
Ranking in Cloud Data Warehouse
4th
Average Rating
7.8
Number of Reviews
64
Ranking in other categories
No ranking in other categories
Teradata Cloud Data Warehouse
Ranking in Cloud Data Warehouse
13th
Average Rating
8.0
Number of Reviews
3
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of July 2024, in the Cloud Data Warehouse category, the mindshare of Amazon Redshift is 9.5%, down from 12.1% compared to the previous year. The mindshare of Teradata Cloud Data Warehouse is 2.3%, up from 1.6% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Cloud Data Warehouse
Unique Categories:
No other categories found
No other categories found
 

Featured Reviews

VictorSokolov - PeerSpot reviewer
May 10, 2024
A powerful database system that works quickly with huge volumes of data
We use the solution to build a data warehouse schema for a target database for analytics. We are uploading data from different transactional databases into Amazon Redshift. We use it for reporting purposes. We use the tool mainly for querying and retrieving the data for analytics The fast…
MartinPotgieter - PeerSpot reviewer
Jul 19, 2023
Is quick, easy to upgrade, and cost-effective
South Africa must significantly improve its internet infrastructure to reduce its high costs. I believe South Africa is one of the most expensive countries in the world when it comes to obtaining high-speed internet connections. We need to establish different service level agreements with clients to ensure we have backup lines and redundancy. The crucial question we need to ask ourselves is, how reliable do we want our internet connection to be? In the case of using cloud services, it's essential to have another line as a backup in case the primary one fails. In our situation, having a backup line is definitely necessary, but it also adds to the expenses. For a major bank like ours, relying on a single connection to the cloud is not feasible; we must have a second line in place to ensure uninterrupted service in case of any issues with the primary line. The cost of Teradata Cloud Data Warehouse has room for improvement.

Quotes from Members

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

Pros

"You can copy JSON to the column and have it analyzed using simple functions."
"Redshift COPY command, because much of my work involved helping customers migrate large amounts of data into Redshift."
"Redshift is a major service of Amazon and is very scalable. It enables faster recalculations and data management, helping to retrieve data quickly."
"In terms of valuable features, I like the columnar storage that Redshift provides. The storage is one of the key features that we're looking for. Also, the data updates and the latency between the data-refreshes."
"For the on-premises version of Amazon Redshift, we need to start from scratch. However, with the cloud version whenever you want to deploy, you can scale up, and down, and it has a data warehousing capability. Redshift has many features."
"The solution's flexibility is its most valuable feature. It's also easy to scale and has relatively painless pricing."
"The product offers good support for the data lake."
"Amazon Redshift is very fast. It has really good response times. It's very user-friendly."
"The cloud is ten times better than physical hardware; it is more cost-effective and the upgrade process is ten times easier."
"The product is reliable."
"The most valuable feature is the ease of running queries."
 

Cons

"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."
"They should provide a better way to work with interim data in a structured way than to store it in parquet files locally."
"There are too many limitations with respect to concurrency."
"The initial setup is a complex process, especially for someone who is not familiar with nodes and configuring terms like RPUs."
"Amazon should provide more cloud-native tools that can integrate with Redshift like Microsoft's development tools for Azure."
"It would be useful to have an option where all of the data can be queried at once and then have the result shown."
"It is difficult to work with unstructured data and JSON documents."
"Planting is the primary key enforcement that should be improved."
"It could be a bit more user-friendly."
"The cost of Teradata Cloud Data Warehouse has room for improvement."
"Stability-wise, we have had some issues with automation and the ability to handle large datasets."
 

Pricing and Cost Advice

"At the moment, pricing is a little bit on the higher side, although it depends on the size of the company."
"Per hour pricing is helpful to keep the costs of a pilot down, but long-term retention is expensive."
"Redshift is very cost effective for a cloud based solution if you need to scale it a lot. For smaller data sizes, I would think about using other products."
"The cost must be improved."
"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."
"The part that I like best is that you only pay for what you are using."
"The product is cheap considering what it provides; I rate it five out of five for affordability."
"BI is sold to our customer base as a part of the initial sales bundle. A customer may elect to opt for a white labeled site for an up-charge."
"Teradata used to be expensive, but they have been lowering their prices."
report
Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
792,694 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Educational Organization
54%
Financial Services Firm
9%
Computer Software Company
7%
Manufacturing Company
4%
Financial Services Firm
21%
Computer Software Company
13%
Government
8%
Comms Service Provider
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
 

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 straightforward. This solution can merge and integrate well with many different dat...
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 when pushing hundreds of terabytes, and its scaling capabilities are good.
What is your experience regarding pricing and costs for Amazon Redshift?
The pricing is reasonable. The cost might increase if we process a huge amount of data.
What do you like most about Teradata Cloud Data Warehouse?
The cloud is ten times better than physical hardware; it is more cost-effective and the upgrade process is ten times easier.
What needs improvement with Teradata Cloud Data Warehouse?
South Africa must significantly improve its internet infrastructure to reduce its high costs. I believe South Africa is one of the most expensive countries in the world when it comes to obtaining h...
What is your primary use case for Teradata Cloud Data Warehouse?
Teradata Cloud Data Warehouse offers a more cost-effective cloud solution. However, the main challenge we encounter, especially in South Africa, is the limited bandwidth available for connecting to...
 

Overview

 

Sample Customers

Liberty Mutual Insurance, 4Cite Marketing, BrandVerity, DNA Plc, Sirocco Systems, Gainsight, Blue 449
Volvo, eBay, P&G, Verizon, 7Eleven, ABN Amro, Alior Bank, BBVA, Cabela's, Dell, DHL, Gortz, Homebase, IHG
Find out what your peers are saying about Amazon Redshift vs. Teradata Cloud Data Warehouse and other solutions. Updated: July 2024.
792,694 professionals have used our research since 2012.