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.
"It is quite easy to manage."
"Can be leveraged with respect to better performance, auto tuning and competition."
"Great scalability and near zero maintenance."
"Data sharing is a good feature. It is a majorly used feature. The elastic compute is another big feature. Separating compute and storage gives you flexibility. It doesn't require much DBA involvement because it doesn't need any performance tuning. We are not really doing any performance tuning, and the entire burden of performance tuning and SQL tuning is on Snowflake. Its usability is very good. I don't need to ramp up any user, and its onboarding is easier. You just onboard the user, and you are done with it. There are simple SQL and UI, and people are able to use this solution easily. Ease of use is a big thing in Snowflake."
"Working with Parquet files is support out of the box and it makes large dataset processing much easier."
"The pricing is reasonable and matches the rest of the market."
"This is the advanced version of the cloud version, so it's really a flexible tool. If you have it implemented at home, you can access it from anywhere."
"It has great flexibility whenever we are loading data and performs ELT (extract, load, transform) techniques instead of ETL."
"It's very mature from a technology perspective."
"Designing the database is easy."
"A conventional and easily defined way to build a data warehouse or a layer of data marts."
"The initial setup was straightforward."
"It handles large amounts of information with a linear performance increase, in relation to a HW investment."
"The most valuable feature of Teradata is security. It runs on Unix and Linux platforms which provide better security."
"The two types of partitioning have been very significant for us - row and columnar partitioning."
"It has a solid set of tools and consulting services."
"The design of the product is easily misunderstood."
"There is a need for improvements in the documentation, this would allow more people to switch over to this solution."
"There are some challenges with loading unstructured data and integrating some message queues or brokers. In one project, we had a problem connecting to one of the message queues and we had to take a different route altogether on Microsoft Azure."
"Snowflake could improve migration. It should be made easier. It would be beneficial if it could offer some OLTP features. One of our customers was using Oracle for both data warehousing and OLTP workloads, and they were able to migrate their data warehousing workloads to Snowflake without major issues. However, for some of their OLTP requirements, such as needing a response time of fewer than 10 milliseconds for certain queries, Snowflake is currently unable to provide that."
"They should improve the reporting tools."
"If they could bring in some tools for data integration, it would be really great."
"The solution could improve the user interface and add functionality to the system."
"In a future release we would like to have a link which would allow us to connect to an external database and create certain views in your own database. This is because it is becoming hard for us to compare the data between multiple sources."
"It would help to make scaling easier with a reduced cost. "
"Limited interest and success in some areas make us hesitate about upgrading."
"The increasing volumes of data demand more and more performance."
"It's primarily designed for big projects and therefore, the pricing is pretty high. It's not suitable for smaller companies."
"The capability to implement it with comparable performance across various private cloud environments, ensuring adaptability to different infrastructure setups would be beneficial."
"Apart from Control-M, it would be nice if it could integrate with other tools."
"I would like to see more integration with many different types of data."
"I think the UI is not there yet. It could be improved by being more user-friendly."
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 Amazon EMR, whereas Teradata is most compared with SQL Server, Oracle Exadata, MySQL, BigQuery and Amazon Redshift. 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.