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."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 initial setup is easy."
"Though Amazon Redshift is good, it depends on what kind of business you're trying to do, what type of analytics you need, and how much data you have."
"It is quite simple to use and there are no issues with creating the tables."
"The most valuable feature of Amazon Redshift is its ability to handle really large sets of data."
"I like the cost-benefit ratio, meaning that it is as easy to use as it is powerful and well-performing."
"I like it because the usage is very similar to Microsoft SQL server. The structure of the query and the temporary tables are very similar."
"I find the most valuable features to be the MPP style of processing, which mostly all of the data warehouses provide. The ability to integrate all other AWS services, such as NSS and S3, with little effort is very helpful. The service is well maintained, there are update patches frequently."
"Designing the database is easy."
"The flexibility in design is very good."
"Their extensive experience in data warehousing, the platform's performance, and their strong reputation in the market are the most valuable."
"The most valuable feature of Teradata is security. It runs on Unix and Linux platforms which provide better security."
"Teradata solutions help organizations reduce IT, operations, and maintenance costs; enhance on-time delivery of products and services."
"The key advantages are Performance when processing Terabytes of data and scalability."
"The two types of partitioning have been very significant for us - row and columnar partitioning."
"Parallel processing features have helped to easily dump any size of data and retrieve data with great performance."
"One area where Amazon Redshift could improve is in adopting the compute-separate, data-separate architecture, which Delta, Snowflake are adopting, and a few others in the cloud data warehouse spectrum."
"AWS Snowflake has a very good feature for cloning databases. It makes it easy to clone a data warehouse, which is useful. I would like to see this feature in Redshift."
"The customer support could be more responsive."
"Amazon Redshift does not have the capability to dynamically increase the VM file."
"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."
"This solution lacks integration with non-AWS sources."
"In our experiments, the handling of unstructured data was not very smooth."
"Should be made available across zones, like other Multi-AZ solutions."
"Teradata's UI could be improved."
"The capability to implement it with comparable performance across various private cloud environments, ensuring adaptability to different infrastructure setups would be beneficial."
"An additional feature I would you like to see included in the next release, is that it needs to be more cloud-friendly."
"Teradata is an old data warehouse, and they're not improving in terms of new, innovative features."
"It needs a teaching web site with more training on third-party tools used for BI."
"It's primarily designed for big projects and therefore, the pricing is pretty high. It's not suitable for smaller companies."
"Teradata's pricing is quite high compared to Redshift, Synapse, or GCP alternatives."
"Teradata could improve by being less complicated. There are some aspects that are not available on the Unix server and a Unix system is required to access some data, such as in case of an emergency."
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.