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."The solution is scalable. It handles different loads very well."
"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 product is relatively easy to use because there is no indexing and no partitions."
"I have primarily used the Redshift Spectrum feature and found it most valuable."
"The product offers good support for the data lake."
"If the analyst knows SQL, which is comfortable and easy to use to go between all of these tool stacks, I think it's reliable. It's a secure and reliable data warehouse."
"It's scalable because it's on the cloud."
"I like the cost-benefit ratio, meaning that it is as easy to use as it is powerful and well-performing."
"Teradata can be easily used in ETL mode transformations, so there is no need for expensive and inconvenient ETL tools"
"Auto-partitioning and indexing, and resource allocation on the fly are key features."
"We really enjoy the FastLoad, TPump, and MultiLoad features."
"The initial setup was straightforward."
"It has a solid set of tools and consulting services."
"Teradata's most valuable feature is that it's easy to use."
"Teradata's capabilities enhance data management efficiency, support scalability, and contribute to faster query performance."
"There are several features of Teradata that I like. One of the most basic is the indexes. I also like that it provides lower TCO. It also has the optimizer feature which is a good feature and isn't found in other legacy systems. Parallelism is also another feature I like in Teradata because when you are running or hosting on multiple systems, you have this shared-nothing architecture that helps. Loading and unloading in Teradata are also really helpful compared to other systems."
"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 initial deployment was complex."
"Improvement could be made in the area of streaming data."
"When working with third-party services requires additional integrations and configurations, which can sometimes add more cost."
"They should provide a better way to work with interim data in a structured way than to store it in parquet files locally."
"Amazon Redshift does not have the capability to dynamically increase the VM file."
"This solution lacks integration with non-AWS sources."
"In our experiments, the handling of unstructured data was not very smooth."
"It's primarily designed for big projects and therefore, the pricing is pretty high. It's not suitable for smaller companies."
"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 solution is stable. However, there are times when we are using large amounts of data and we can see some latency issues."
"Teradata can improve the way it handles big data and unstructured data."
"Teradata's UI could be improved."
"The setup is not straightforward."
"I think the UI is not there yet. It could be improved by being more user-friendly."
"Teradata hardly supports unstructured data or semi-structured data"
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 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.