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 most valuable features of Snowflake are its performance and power."
"I like the ability to work with a managed service on the cloud and that is easy to start with."
"Snowflake has a variety of other ETL provisions that they provide. You can use your own ETL pipeline. Additionally, they provide adapters, and they are always evolving, it is a well-developed solution."
"The most valuable feature is the clone copy."
"It is a very well-distributed system. It has different data engines for different applications. Many applications can use different computational engines at the same time. In terms of data processing, the feeling was similar to working with a relational database but in a scalable way."
"A user-friendly and reliable solution."
"I like the idea that you can assign roles and responsibilities, limiting access to data."
"The distributed architecture of Snowflake has the capacity to process huge datasets faster and allows us to scale up and down according to our needs."
"The cloud is ten times better than physical hardware; it is more cost-effective and the upgrade process is ten times easier."
"The most valuable feature is the ease of running queries."
"The product is reliable."
"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."
"Portability is a big hurdle right now for our clients. Porting all of your existing SQL ecosystem, such as stored procedures, to Snowflake is a major pain point. Currently, Snowflake stored procedures use JavaScript, but they should support SQL-based stored procedures. It would be a huge advantage if you can write your stored procedures using SQL. It seems that they are working on this feature, and they are yet to release it. I remember seeing some notes saying that they were going to do that in the future, but the sooner this feature comes out, it would be better for Snowflake because there are a lot of clients with whom I'm interacting, and their main hurdle is to take their existing Oracle or SQL Server stored procedures and move them into Snowflake. For this, you need to learn JavaScript and how it works, which is not easy and becomes a little tricky. If it supports SQL-based procedures, then you can just cut-paste the SQL code, run it, and easily fix small issues."
"Snowflake can improve its machine learning and AI capabilities."
"Room for improvement would be writebacks. It doesn't support extensively writing back to the database, and it doesn't support web applications effectively. Ultimately, it's a database call, so if we are building web applications using Snowflake, it isn't that effective because there is some turnaround time from the database."
"We would like to have an on-premises deployment option that has the same features, including scalability."
"From the documentation, the black box is not very descriptive. Snowflake does not reveal how exactly the data is processed or sourced."
"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."
"The product's performance could be improved."
"It could be a bit more user-friendly."
"The cost of Teradata Cloud Data Warehouse has room for improvement."
"Stability-wise, we have had some issues with automation and the ability to handle large datasets."
More Teradata Cloud Data Warehouse Pricing and Cost Advice →
Snowflake is ranked 1st in Cloud Data Warehouse with 94 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.