We performed a comparison between Snowflake and Teradata based on our users’ reviews in five categories. After reading all of the collected data, you can find our conclusion below.
Comparison Results: Both solutions received high marks from users. Snowflake comes out on top in this comparison. It is a powerful and reliable product that is easy to deploy. In addition, its users feel that it is reasonably priced.
"The snapshot feature is good, the rollback feature is good and the interface is user-friendly."
"Data Science capabilities are the most valuable feature."
"Snowflake's most valuable features are data enrichment and flattening."
"From a data warehouse perspective, it's an excellent all-round solution. It's very complete."
"The most valuable features are the clustering, LS50, being able to change the size, the pay per use feature, the flexibility with many different sources and analytic applications."
"Its speed and performance were the most valuable. Easy configuration of Snowflake in any cloud was also a benefit."
"Its performance is a big advantage. When you run a query, its performance is very good. The inbound and outbound share features are also very useful for sharing a particular database. By using these features, you can allow others to access the Snowflake database and query it, which is another advantage of this solution. It has good security, and we can easily integrate it. We can connect it with multiple source systems."
"The most valuable features of Snowflake are its performance and power."
"We did performance testing. We had a set of real life MicroStrategy reports. Our conditions were: Not allowed to redesign data model, not allowed to rewrite the queries, all queries should be generated by MicroStrategy, no aggregates. Teradata appeared to be way faster than a similarly configured (in terms of hardware) Oracle server."
"Building a data warehouse with Teradata has definitely helped a lot of our downstream applications to more easily access information."
"Teradata has good performance, the response times are very fast. Overall the solution is easy to use. When we do the transformation, we have all of our staging and aggregation data available."
"Viewpoint, the detailed query logs and performance statistics are valuable features."
"The key advantages are Performance when processing Terabytes of data and scalability."
"Teradata's best feature is its speed with historical data."
"The performance is great, we are able to query our data in one operation."
"Parallel processing features have helped to easily dump any size of data and retrieve data with great performance."
"The pricing of the solution should be much easier to calculate or find by yourself."
"We would like to see more security including more masking and more encryption at the database level."
"I see room for improvement when it comes to credit performance. The other thing I'd like to be improved is the warehouse facility."
"The solution could improve by allowing non-structured data, such as PDFs, images, or videos. We cannot see the data."
"It would be helpful if Snowflake could create good reports instead of using Power BI reports."
"The solution could use a little bit more UI."
"For the Snowflake database, there should be some third-party features for the ETL. It would also be good to be able to use some kind of controls to get the data either from another database or a flat file. Its price should be improved. It should be cheaper than Microsoft."
"If we can have a feature where the results can be moved to different tabs, so that I can compare the results with earlier queries before applying the changes, it would be great."
"Limited interest and success in some areas make us hesitate about upgrading."
"I've been using the same UI for 20 years in Teradata. It could use some updating. Adding more stability around Teradata Studio would be outstanding. Teradata Studio is a Java-based version of their tool. It's much better now, but it still has some room for improvement."
"The solution needs improvement in its stability, support and pricing."
"The capability to implement it with comparable performance across various private cloud environments, ensuring adaptability to different infrastructure setups would be beneficial."
"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."
"The increasing volumes of data demand more and more performance."
"The following could be better: licensing, architecture openness, integration with other tools."
"Apart from Control-M, it would be nice if it could integrate with other tools."
Snowflake is ranked 1st in Data Warehouse with 94 reviews while Teradata is ranked 3rd in Data Warehouse with 54 reviews. Snowflake is rated 8.4, while Teradata is rated 8.2. The top reviewer of Snowflake writes "Good usability, good data sharing and elastic compute features, and requires less DBA involvement". 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". Snowflake is most compared with BigQuery, Azure Data Factory, Vertica, AWS Lake Formation and Oracle Autonomous Data Warehouse, whereas Teradata is most compared with SQL Server, Oracle Exadata, MySQL, BigQuery and IBM Db2 Database. See our Snowflake 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.