We performed a comparison between Amazon Redshift and Teradata based on real PeerSpot user reviews.
Find out in this report how the two Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."Amazon Redshift offers a relatively flexible structure...I rate the technical support a nine out of ten."
"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."
"I like the cost-benefit ratio, meaning that it is as easy to use as it is powerful and well-performing."
"The solution is scalable. It handles different loads very well."
"Setup is easy. It's a fast solution with machine learning features, good integration, and a good API."
"Redshift Spectrum is the most valuable feature."
"The initial setup is easy."
"The main benefit is that our portal for end users is running in AWS, so we can easily connect it to other AWS services."
"The flexibility in design is very good."
"The solution scales well on the cloud."
"The most valuable features are the large volume of data and the structuring of the data to optimize it and get very optimal data warehouse solutions for customers."
"Teradata solutions help organizations reduce IT, operations, and maintenance costs; enhance on-time delivery of products and services."
"The most valuable feature of Teradata is security. It runs on Unix and Linux platforms which provide better security."
"Teradata's best feature is its speed with historical data."
"Parallel processing features have helped to easily dump any size of data and retrieve data with great performance."
"I like this solution's ease of design and the fact that its performance is quite good. It is stable as well."
"The technical support should be better in terms of their knowledge, and they should be more customer-friendly."
"The initial setup is a complex process, especially for someone who is not familiar with nodes and configuring terms like RPUs."
"Redshift's GUI could be more user-friendly. It's easier to perform queries and all that stuff in Azure Synapse Analytics."
"Should be made available across zones, like other Multi-AZ solutions."
"In the next release, a pivot function would be a big help. It could save a lot of time creating a query or process to handle operations."
"Amazon Redshift is a little more expensive than other products."
"Planting is the primary key enforcement that should be improved."
"What would make Amazon Redshift better is improvising on the pricing structure. For example, Acronis provides backups in cybersecurity, yet the pricing is a bit lesser than Amazon Redshift."
"The scalability could be better. The on-premises solution is always more complicated to scale."
"Teradata can improve the way it handles big data and unstructured data."
"The setup is not straightforward."
"The user interface needs to be improved."
"The cloud is the new challenge and the new opportunity."
"The SQL Assistant is very basic. This tool can be improved for usability."
"There is some improvement required on OLTP level and some analytical function is missing."
"I would like to see an improved Knowledge Base on the web."
Amazon Redshift is ranked 4th in Cloud Data Warehouse with 61 reviews while Teradata is ranked 3rd in Data Warehouse with 54 reviews. Amazon Redshift is rated 7.8, while Teradata is rated 8.2. 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 Teradata writes "Offers seamless integration capabilities and performance optimization features, including extensive indexing and advanced tuning capabilities". Amazon Redshift is most compared with Vertica, Snowflake, Microsoft Azure Synapse Analytics, AWS Lake Formation and Oracle Exadata, whereas Teradata is most compared with SQL Server, Snowflake, Oracle Exadata, MySQL and Microsoft Azure Synapse Analytics. See our Amazon Redshift vs. Teradata report.
See our list of best Data Warehouse vendors and best Cloud Data Warehouse vendors.
We monitor all 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.