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 overall ecosystem was easy to manage. Given that we weren't a very highly technical group, it was preferable to other things we looked at because it could do all of the cloud tunings. It can tune your data warehouse to an appropriate size for controlled billing, resume and sleep functions, and all such things. It was much more simple than doing native Azure or AWS development. It was stable, and their support was also perfect. It was also very easy to deploy. It was one of those rare times where they did exactly what they said they could do."
"Very easy to use and easy to query."
"The solution is easy to use."
"Everything is automatic, and I don't have to do any maintenance."
"I like Snowflake's data exchange capabilities. It can exchange data with downstream systems and other vendor partners as well."
"The product is quite fast."
"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 adaptation to development languages is most valuable. Our developers can SQL code or something else. It has been convenient in that regard."
"It effectively has allowed us to remove over 20 portion copies of the data sets on other DB platforms for real-time operational reporting purposes."
"We really enjoy the FastLoad, TPump, and MultiLoad features."
"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."
"Parallel processing features have helped to easily dump any size of data and retrieve data with great performance."
"Improved performance of ETL procedures, reporting."
"Teradata's pretty fast."
"Auto-partitioning and indexing, and resource allocation on the fly are key features."
"It handles large amounts of information with a linear performance increase, in relation to a HW investment."
"The UI could improve because sometimes in the security query the UI freezes. We then have to close the window and restart."
"The solution could improve the user interface and add functionality to the system."
"The aspect of it that was more complicated was stored procedures. It does not support SQL language-based stored procedures. You have to write in JavaScript. If they supported SQL language and stored procedures, it would make migration from on-prem much simpler. In most cases, if an on-prem solution has stored procedures, they're usually written in SQL. They're not written as what most on-prem DBMS would refer to as an external stored procedure, which is what these feel like to most people because they're written in a language outside of SQL."
"I don't know about GCP, if they have connected for GCP. If they don't, they should allow for it."
"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."
"We are yet to figure out how to integrate tools, such as Liquibase, to release changes to our data warehouse model."
"It's not that flexible when compared to Oracle."
"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."
"I'm not sure about the unstructured data management capabilities. It could be improved."
"It would help to make scaling easier with a reduced cost. "
"The solution is stable. However, there are times when we are using large amounts of data and we can see some latency issues."
"Teradata's UI could be improved."
"It's primarily designed for big projects and therefore, the pricing is pretty high. It's not suitable for smaller companies."
"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."
"Needs compatibility with more Big Data platforms."
"Teradata hardly supports unstructured data or semi-structured data"
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.