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 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."
"It requires no maintenance on our part. They handle all that. The speed is phenomenal. The pricing isn't really anything more than what you would be paying for a SQL server license or another tool to execute the same thing. We have zero maintenance on our side to do anything and the speed at which it performs queries and loads the data is amazing. It handles unstructured data extremely well, too. So, if the data is in a JSON array or an XML, it handles that super well."
"It is very fast and the performance is great."
"The solution is very stable."
"This solution has helped our organization by being easy to maintain and having good technical support."
"Its performance is most valuable. As compared to SQL Server, we are able to see a significant improvement in performance with Snowflake."
"The features that I have found most valuable are the ease of use, the rapidness, how quickly the solution can be implemented, and of course that it's been very easy to move from the on-premise world to the Cloud world because Snowflake is based on SQL also."
"The Time Travel feature is helpful for accessing historical data and the ability to clone external tables is useful."
"The initial setup was straightforward."
"We really enjoy the FastLoad, TPump, and MultiLoad features."
"We did performance testing. We had a set of real life MicroStrategy reports. Our conditions were: Not allowed to redesign data model, not allowed to rewrite the queries, all queries should be generated by MicroStrategy, no aggregates. Teradata appeared to be way faster than a similarly configured (in terms of hardware) Oracle server."
"It's a pre-configured appliance that requires very little in terms of setting-up."
"I found all parts --loading, transformation, processing & querying work in parallel, and end-to-end-- to be valuable."
"It has given our business the ability to gain insights into the data and create data labs for analysis and PoCs."
"Teradata is a great, industry-leading data warehousing product that has MPP architecture."
"It is a stable program."
"I can only access Snowflake from the web. It would be better if we could have an app that we can install locally on our laptops to connect to the server without needing to go to the web page. Apart from that, it's hard to point out any limitations in the tool."
"We would like to have an on-premises deployment option that has the same features, including scalability."
"For the Snowflake database, there should be some third-party features for the ETL. It would also be good to be able to use some kind of controls to get the data either from another database or a flat file. Its price should be improved. It should be cheaper than Microsoft."
"They don't have any SLAs in place. It would be better if they did."
"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."
"If we can have a feature where the results can be moved to different tabs, so that I can compare the results with earlier queries before applying the changes, it would be great."
"The scheduling system can definitely be better because we had to use external airflow for that. There should be orchestration for the scheduling system. Snowflake currently does not support machine learning, so it is just storage. They also need some alternatives for SQL Query. There should also be support for Spark in different languages such as Python."
"The data science functionality could be improved in terms of the machine learning process."
"Teradata could improve by being less complicated. There are some aspects that are not available on the Unix server and a Unix system is required to access some data, such as in case of an emergency."
"Sometimes the large injestion takes days to load data, and some of our stored procedures take two to three days."
"Teradata is a bit late for the cloud."
"Apart from Control-M, it would be nice if it could integrate with other tools."
"The current operational approach needs improvement."
"The increasing volumes of data demand more and more performance."
"It would help to make scaling easier with a reduced cost. "
"GUI of administrative tools is really outdated."
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.