We performed a comparison between Snowflake and Teradata Cloud Data Warehouse based on real PeerSpot user reviews.
Find out in this report how the two Cloud Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."The adaptation to development languages is most valuable. Our developers can SQL code or something else. It has been convenient in that regard."
"As long as you don't need to worry about the storage or cost, this solution would be one of the best ones on the market for scalability purposes."
"Snowflake is a database, and it is very good and useful. The most interesting part is that memory management is very good in Snowflake. For a business intelligence project, SQL Server is taking a lot of time for reporting services. There are a lot of calculations, and the reporting time is shown as two minutes, whereas Snowflake is taking just two seconds for the same reporting services."
"The most valuable feature of Snowflake is its performance. We can access the data quickly. Additionally, it handles structured and non-structured data."
"This is the advanced version of the cloud version, so it's really a flexible tool. If you have it implemented at home, you can access it from anywhere."
"The integration capabilities of the product are good and you get what you pay for when it comes to Snowflake."
"The initial setup is very simple."
"From a data warehouse perspective, it's an excellent all-round solution. It's very complete."
"The cloud is ten times better than physical hardware; it is more cost-effective and the upgrade process is ten times easier."
"The product is reliable."
"The most valuable feature is the ease of running queries."
"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."
"There are three things that came to my notice. I am not very sure whether they have already done it. The first one is very specific to the virtual data warehouse. Snowflake might want to offer industry-specific models for the data warehouse. Snowflake is a very strong product with credit. For a typical retail industry, such as the pharma industry, if it can get into the functional space as well, it will be a big shot in their arm. The second thing is related to the migration from other data warehouses to Snowflake. They can make the migration a little bit more seamless and easy. It should be compatible, well-structured, and well-governed. Many enterprises have huge impetus and urgency to move to Snowflake from their existing data warehouse, so, naturally, this is an area that is critical. The third thing is related to the capability of dealing with relational and dimensional structures. It is not that friendly with relational structures. Snowflake is more friendly with the dimensional structure or the data masks, which is characteristic of a Kimball model. It is very difficult to be savvy and friendly with both structures because these structures are different and address different kinds of needs. One is manipulation-heavy, and the other one is read-heavy or analysis-heavy. One is for heavy or frequent changes and amendments, and the other one is for frequent reads. One is flat, and the other one is distributed. There are fundamental differences between these two structures. If I were to consider Snowflake as a silver bullet, it should be equally savvy on both ends, which I don't think is the case. Maybe the product has grown and scaled up from where it was."
"There are some challenges with loading unstructured data and integrating some message queues or brokers. In one project, we had a problem connecting to one of the message queues and we had to take a different route altogether on Microsoft Azure."
"From the documentation, the black box is not very descriptive. Snowflake does not reveal how exactly the data is processed or sourced."
"The UI could improve because sometimes in the security query the UI freezes. We then have to close the window and restart."
"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."
"Its transaction application needs improvement."
"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."
"Stability-wise, we have had some issues with automation and the ability to handle large datasets."
"The cost of Teradata Cloud Data Warehouse has room for improvement."
"It could be a bit more user-friendly."
More Teradata Cloud Data Warehouse Pricing and Cost Advice →
Snowflake is ranked 1st in Cloud Data Warehouse with 95 reviews while Teradata Cloud Data Warehouse is ranked 13th in Cloud Data Warehouse with 3 reviews. Snowflake is rated 8.4, while Teradata Cloud Data Warehouse is rated 8.0. 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 Cloud Data Warehouse writes "Is quick, easy to upgrade, and cost-effective". Snowflake is most compared with BigQuery, Azure Data Factory, Teradata and Vertica, whereas Teradata Cloud Data Warehouse is most compared with Amazon Redshift, Teradata, Oracle Exadata, Microsoft Azure Synapse Analytics and Vertica. See our Snowflake vs. Teradata Cloud Data Warehouse report.
See our list of best Cloud Data Warehouse vendors and best Data Warehouse vendors.
We monitor all Cloud 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.