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."You can copy JSON to the column and have it analyzed using simple functions."
"Easy to build out our snowflake design and load data."
"I have primarily used the Redshift Spectrum feature and found it most valuable."
"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 processing of data is very fast."
"The solution is scalable. It handles different loads very well."
"Redshift's versioning and data security are the two most critical features. When migrating into the cloud, it's vital to secure the data. The encryption and security are there."
"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."
"It is a solid database a lot of different tools to move data."
"It's a pre-configured appliance that requires very little in terms of setting-up."
"The most valuable features are the Shared-nothing architecture and data protection functionality."
"I like this solution's ease of design and the fact that its performance is quite good. It is stable as well."
"It has a solid set of tools and consulting services."
"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."
"When it comes to integration, tools like Informatica seamlessly connect with Teradata. We ensure the Teradata database is configured correctly in Informatica, including the proper hostname and properties for the load process. We didn't find any major complexity or issues with integration."
"Building a data warehouse with Teradata has definitely helped a lot of our downstream applications to more easily access information."
"The customer support could be more responsive."
"Infinite storage is available in Snowflake and is not available in Redshift."
"Running parallel queries results in poor performance and this needs to be improved."
"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."
"If you require a highly scalable solution, I would not recommend Amazon Redshift."
"The initial setup is a complex process, especially for someone who is not familiar with nodes and configuring terms like RPUs."
"Should be made available across zones, like other Multi-AZ solutions."
"Amazon Redshift does not have the capability to dynamically increase the VM file."
"Data ingestion is done via external utilities and not by the query language itself. It would be more convenient to have that functionality within its SQL dialect."
"GUI of administrative tools is really outdated."
"It could use some more advanced analytics relating to structured and semi-structured data."
"Since I was working on the very basic, legacy systems, the memory thing was always a challenge. If Teradata is moving to the cloud, the space constraint or the memory issue that my company generally faces will eventually resolve, in time. What I'd like to see in the next release of Teradata is that it becomes full-fledged on the cloud, apart from better connectivity to various systems. For example, if I have to read or include a Python script, if I write some basic codes, I should be able to read even unstructured data. I know that it's not supported even in Snowflake, but at least semi-structured data support, if that can be a little more enhanced, that would be good."
"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."
"Teradata can improve the way it handles big data and unstructured data."
"Needs compatibility with more Big Data platforms."
"Teradata needs to pay attention to the cloud-based solution to make sure it runs smoothly."
Amazon Redshift is ranked 4th in Cloud Data Warehouse with 58 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 AWS Lake Formation, Snowflake, 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.