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."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."
"The valuable features are performance, data compression, and scalability."
"Redshift has an advantage when it comes to administration, making it easier to manage and collaborate."
"Redshift Spectrum is the most valuable feature."
"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."
"The solution has very competitive pricing."
"The most valuable feature is that the solution is fully embedded in the AWS stack."
"The stability of Amazon Redshift is good."
"A conventional and easily defined way to build a data warehouse or a layer of data marts."
"Auto-partitioning and indexing, and resource allocation on the fly are key features."
"I've never had any issues with scalability."
"The most valuable feature of Teradata is the quick processing of large data."
"Teradata can be deployed on-premise, on the cloud, or in a virtual machine, which means customers can move without having to create their architecture all over again."
"The initial setup was straightforward."
"Teradata's best feature is its speed with historical data."
"The functionality of the solution is excellent."
"When working with third-party services requires additional integrations and configurations, which can sometimes add more cost."
"Should be made available across zones, like other Multi-AZ solutions."
"The solution could improve in handling more data formats and more native support for RDF."
"The OLAP slide and dice features need to be improved."
"The product could be improved by making it more flexible."
"We are using third-party tools to integrate Amazon Redshift, they should create their own interface on their own for it to be easily connected on the AWS itself."
"The explain panel in the Redshift database could be better."
"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."
"Teradata's pricing is quite high compared to Redshift, Synapse, or GCP alternatives."
"An additional feature I would you like to see included in the next release, is that it needs to be more cloud-friendly."
"Sometimes the large injestion takes days to load data, and some of our stored procedures take two to three days."
"It's primarily designed for big projects and therefore, the pricing is pretty high. It's not suitable for smaller companies."
"I'm not sure about the unstructured data management capabilities. It could be improved."
"Teradata's UI could be improved."
"The solution could improve by having a cloud version or a cloud component. We have to use other solutions, such as Amazon AWS, Microsoft Azure, or Snowflake for the cloud."
"The cloud is the new challenge and the new opportunity."
Amazon Redshift is ranked 4th in Cloud Data Warehouse with 59 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 Snowflake, AWS Lake Formation, Vertica, Microsoft Azure Synapse Analytics 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.