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 product is quite fast."
"It has great flexibility whenever we are loading data and performs ELT (extract, load, transform) techniques instead of ETL."
"The tool's performance is good. I think it's the best in the game right now. It usually charges per query. For example, if you run a SQL query on Snowflake with the same number of data records, it would take less than half the time compared to running it on Microsoft. It has good documentation. You can pick up Snowflake if you have previous knowledge of SQL."
"The speed of data loading and being able to quickly create the environment are most valuable."
"The most valuable features of Snowflake are that you have to pay per usage, and you don't have to worry about the maintenance of the data warehouse because it is on the cloud."
"The way it is built and designed is valuable. The way the shared model is built and the way it exploits the power of the cloud is very good. Certain features related to administration and management, akin to Oracle Flashback and all that, are very important for modern-day administration and management. It is also good in terms of managing and improving performance, indexing, and partitioning. It is sort of completely automated. Everything is essentially under the hood, and the engine takes care of it all. As a data warehouse on the cloud, Snowflake stands strong on its ground even though each of the cloud providers has its own data warehouse, such as Redshift for AWS or Synapse for Azure."
"It is a highly scalable solution. There is no limit on storage or computing."
"This solution has helped our organization by being easy to maintain and having good technical support."
"It's very, very fast"
"Auto-partitioning and indexing, and resource allocation on the fly are key features."
"Teradata's most valuable feature is that it's easy to use."
"Teradata's capabilities enhance data management efficiency, support scalability, and contribute to faster query performance."
"The most valuable feature of Teradata is security. It runs on Unix and Linux platforms which provide better security."
"The flexibility in design is very good."
"It's very mature from a technology perspective."
"It is a solid database a lot of different tools to move data."
"I would like to see more transparency in data processing, ATLs, and compute areas - which should give more comfort to the end users."
"The pricing of the solution should be much easier to calculate or find by yourself."
"These days, they are pushing users towards the GUI or graphical version. However, I am more familiar with the classic version. I'd like to continue to work with it using the older approach."
"Snowflake has to improve their spatial parts since it doesn't have much in terms of geo-spatial queries."
"There are a lot of features that they need to come up with. A lot of functions are missing in Snowflake, so we have to find a workaround for those. For example, OUTER APPLY is a basic function in SQL Server, but it is not there in Snowflake. So, you have to write complex code for it."
"There could be better ELT tools that are appropriate for Snowflake. We decided on Matillion and it seemed to be the only one. There need to be better choices, it would be great if Snowflake provided an ELT solution that people could use. Additionally, if there was a pure cloud-based ELT tool it would be useful."
"They don't have any SLAs in place. It would be better if they did."
"It would be helpful if Snowflake could create good reports instead of using Power BI reports."
"The setup is not straightforward."
"The scalability could be better. The on-premises solution is always more complicated to scale."
"The current operational approach needs improvement."
"The increasing volumes of data demand more and more performance."
"Needs compatibility with more Big Data platforms."
"The user interface needs to be improved."
"Teradata's pricing is quite high compared to Redshift, Synapse, or GCP alternatives."
"There is some improvement required on OLTP level and some analytical function is missing."
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.