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."Data sharing is a good feature. It is a majorly used feature. The elastic compute is another big feature. Separating compute and storage gives you flexibility. It doesn't require much DBA involvement because it doesn't need any performance tuning. We are not really doing any performance tuning, and the entire burden of performance tuning and SQL tuning is on Snowflake. Its usability is very good. I don't need to ramp up any user, and its onboarding is easier. You just onboard the user, and you are done with it. There are simple SQL and UI, and people are able to use this solution easily. Ease of use is a big thing in Snowflake."
"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."
"The way it is built and designed is valuable. The way the shared model is built and the way it exploits the power of the cloud is very good. Certain features related to administration and management, akin to Oracle Flashback and all that, are very important for modern-day administration and management. It is also good in terms of managing and improving performance, indexing, and partitioning. It is sort of completely automated. Everything is essentially under the hood, and the engine takes care of it all. As a data warehouse on the cloud, Snowflake stands strong on its ground even though each of the cloud providers has its own data warehouse, such as Redshift for AWS or Synapse for Azure."
"This solution has helped our organization by being easy to maintain and having good technical support."
"The most valuable feature has been the Snowflake data sharing and dynamic data masking."
"They separate compute and storage. You can scale storage independently of the computer, or you can scale computing independently of storage. If you need to buy more computer parts you can add new virtual warehouses in Snowflake. Similarly, if you need more storage, you take more storage. It's most scalable in the database essentially; typically you don't have this scalability independence on-premises."
"Very easy to use and easy to query."
"Snowflake is scalable both in terms of the amount of data that you can run through it and the number of users that engage with it."
"The product is reliable."
"The most valuable feature is the ease of running queries."
"The cloud is ten times better than physical hardware; it is more cost-effective and the upgrade process is ten times easier."
"If they could bring in some tools for data integration, it would be really great."
"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."
"Pricing is an issue for many customers."
"The pricing of the solution should be much easier to calculate or find by yourself."
"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."
"Snowflake could improve if they had an Operational Data Store(ODS) space."
"Support needs improvement, as it can take several days before you get some initial support."
"The documentation could improve. They should provide architecture information."
"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."
"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 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.