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 most efficient way for real-time dashboards or analytical business intelligence reports to be sent to the customer."
"The solution is stable."
"The most valuable feature of Snowflake is it's an all-in-one data warehousing solution."
"The distributed architecture of Snowflake has the capacity to process huge datasets faster and allows us to scale up and down according to our needs."
"The cloning functionality has been the most valuable. I have been able to completely copy databases. The data sharing concept is also useful. As compared to, for example, SAP, Snowflake is a lot more open, and it allows a lot more connectivity for other providers than an SAP ecosystem."
"They separate compute and storage. You can scale storage independently of the computer, or you can scale computing independently of storage. If you need to buy more computer parts you can add new virtual warehouses in Snowflake. Similarly, if you need more storage, you take more storage. It's most scalable in the database essentially; typically you don't have this scalability independence on-premises."
"It's ultra-fast at handling queries, which is what we find very convenient."
"Very easy to use and easy to query."
"It handles large amounts of information with a linear performance increase, in relation to a HW investment."
"The initial setup was straightforward."
"The solution scales well on the cloud."
"It's very, very fast"
"I found all parts --loading, transformation, processing & querying work in parallel, and end-to-end-- to be valuable."
"A conventional and easily defined way to build a data warehouse or a layer of data marts."
"The most valuable feature of Teradata is security. It runs on Unix and Linux platforms which provide better security."
"The most valuable features are the Shared-nothing architecture and data protection functionality."
"These aren't as crucial, but there are common errors sometimes where the database is down, or a table is nullified and a new table is added and you are not given access to that. With those errors, you don't have permissions."
"They need to improve its ETL functionality so that Snowflake becomes an ETL product. Snowpipe can do some pipelines and data ingestion, but as compare to Talend, these functionalities are limited. The ETL feature is not good enough. Therefore, Snowflake can only be used as a database. You can't use it as an ETL tool, which is a limitation. We have spoken to the vendor, and they said they are working on it, but I'm not sure when they will bring it to production."
"More data governance and access control features would be a welcome addition."
"Its pricing or affordability is one of the big challenges. Pricing was the only thing that we didn't like about Snowflake. In terms of technical features, it is a complete solution."
"Every product has room for improvement, although in this case, it needs some broadening of the functionality."
"Pricing is an issue for many customers."
"We would like to be able to do modeling with Snowflake. It should support statistical modeling."
"I would like to see a client version of the GUI."
"Teradata needs to expand the kind of training that's available to customers. Teradata only offers training directly and doesn't delegate to any third-party companies. As a result, it's harder to find people trained on Teradata in our market relative to Oracle."
"There is some improvement required on OLTP level and some analytical function is missing."
"The SQL Assistant is very basic. This tool can be improved for usability."
"It's primarily designed for big projects and therefore, the pricing is pretty high. It's not suitable for smaller companies."
"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."
"Teradata is an expensive tool. Like, if you're already using Microsoft products like Windows, they'll market all their products together. And with the rise of cloud technologies, companies will adopt solutions that offer them some privileges or facilities. Similar to how SAP does it in the market, so do Microsoft and other companies. Even Oracle and other such tools are quite commonly seen compared to Teradata's competitors in everyday solutions."
"Teradata should focus on functionality for building predictive models because, in that regard, it can definitely improve."
"The current operational approach needs improvement."
Snowflake is ranked 1st in Data Warehouse with 92 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.