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 adaptation to development languages is most valuable. Our developers can SQL code or something else. It has been convenient in that regard."
"The solution speeds up the process of onboarding."
"It is a cloud solution with many useful features. It has the data science capability. It can transform data and prepare data for a data science project with scalability."
"The pricing is reasonable and matches the rest of the market."
"Snowflake is an enormously useful platform. The Snowpipe feature is valuable because it allows us to load terabytes and petabytes of data into the data mart at a very low cost."
"Once you have finished your designs they can be easily imported to Snowflake and the information can be readily accessed without an IT expert."
"Great scalability and near zero maintenance."
"The ability to share the data and the ability to scale up and down easily are the most valuable features. The concept of data sharing and data plumbing made it very easy to provide and share data. The ability to refresh your Dev or QA just by doing a clone is also valuable. It has the dynamic scale up and scale down feature. Development and deployment are much easier as compared to other platforms where you have to go through a lot of stuff. With a tool like DBT, you can do modeling and transformation within a single tool and deploy to Snowflake. It provides continuous deployment and continuous integration abilities. There is a separation of storage and compute, so you only get charged for your usage. You only pay for what you use. When we share the data downstream with business partners, we can specifically create compute for them, and we can charge back the business."
"The two types of partitioning have been very significant for us - row and columnar partitioning."
"Designing the database is easy."
"Teradata solutions help organizations reduce IT, operations, and maintenance costs; enhance on-time delivery of products and services."
"Parallel processing features have helped to easily dump any size of data and retrieve data with great performance."
"Things have started moving faster in my company, such as data retrieval happens more quickly."
"It is a stable program."
"Their extensive experience in data warehousing, the platform's performance, and their strong reputation in the market are the most valuable."
"The feature that we find most valuable is its ability to perform Massive Parallel Processing."
"It needs a bit more rigor and governance, which is something you don't get with newer tools. This makes it less enterprise scalable. Its governance and structure can be enhanced, which would really be valuable. I would like to see some kind of prebuilt functionality in terms of having almost like a pre-built data warehouse. A functionality for generating automated kind of pieces would be good."
"They do have a native connector to connect with integration tools for loading data, but it would be much better to have the functionality built-in."
"Support needs improvement, as it can take several days before you get some initial support."
"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."
"Its stability could be better."
"The product's performance could be improved."
"It's difficult to know how to size everything correctly."
"Availability is a problem."
"Teradata needs to pay attention to the cloud-based solution to make sure it runs smoothly."
"Teradata's UI could be more user-friendly."
"It needs a teaching web site with more training on third-party tools used for BI."
"I would like to see an improved Knowledge Base on the web."
"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."
"Query language and its functionality are rather limited, compared to Oracle or even SQL Server. However, it is possible to perform any kind of logic in it (though some workarounds may be required)."
"There is some improvement required on OLTP level and some analytical function is missing."
"The following could be better: licensing, architecture openness, integration with other tools."
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.