IT Central Station is now PeerSpot: Here's why
Cancel
You must select at least 2 products to compare!
Snowflake Computing Logo
38,560 views|28,984 comparisons
Teradata Logo
12,526 views|9,991 comparisons
Executive Summary
Updated on May 29, 2022

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.

  • Ease of Deployment: Snowflake users say the initial setup is straightforward and easy. While some Teradata reviewers report the initial setup to be straightforward, others feel that the setup can be complex and requires a higher level of technical expertise.

  • Features: Users of both products are happy with their stability and scalability. Snowflake users like its data sharing features and say it is flexible, fast, and secure. Several users mention that they would like more support for SQL language querying. Teradata users say it performs well and offers good data warehousing. A number of users would like Teradata to provide better training for the solution.
  • Pricing: Most Snowflake users say it is reasonably priced. In contrast, most Teradata users feel that it is an expensive product.
  • ROI: Users are satisfied with the ROI of both products.

  • Service and Support: Users of both solutions report being satisfied with the level of the support they receive.

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.

To learn more, read our detailed Snowflake vs. Teradata report (Updated: May 2022).
Buyer's Guide
Snowflake vs. Teradata
May 2022
Find out what your peers are saying about Snowflake vs. Teradata and other solutions. Updated: May 2022.
608,010 professionals have used our research since 2012.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"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 syntax is advanced which reduces the time to write code.""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.""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.""The most efficient way for real-time dashboards or analytical business intelligence reports to be sent to the customer.""The adaptation to development languages is most valuable. Our developers can SQL code or something else. It has been convenient in that regard.""Its speed and performance were the most valuable. Easy configuration of Snowflake in any cloud was also a benefit."

More Snowflake Pros →

"Teradata has good performance, the response times are very fast. Overall the solution is easy to use. When we do the transformation, we have all of our staging and aggregation data available.""The functionality of the solution is excellent.""The most valuable features of Teradata are that it is a massively parallel platform and I can receive a lot of data and get the queries out correctly, especially if it's been appropriately designed. The native features make it very suitable for multiple large data tasks in a structured data environment. Additionally, the automation is very good.""The flexibility in design is very good.""I like this solution's ease of design and the fact that its performance is quite good. It is stable as well.""There are several features of Teradata that I like. One of the most basic is the indexes. I also like that it provides lower TCO. It also has the optimizer feature which is a good feature and isn't found in other legacy systems. Parallelism is also another feature I like in Teradata because when you are running or hosting on multiple systems, you have this shared-nothing architecture that helps. Loading and unloading in Teradata are also really helpful compared to other systems.""The performance is great, we are able to query our data in one operation.""Teradata's most valuable feature is that it's easy to use."

More Teradata Pros →

Cons
"The documentation could improve. They should provide architecture information.""They don't have any SLAs in place. It would be better if they did.""The UI could improve because sometimes in the security query the UI freezes. We then have to close the window and restart.""They need to incorporate some basic OLAP capabilities in the backend or at the database level. Currently, it is purely a database. They call it purely a data warehouse for the cloud. Currently, just like any database, we have to calculate all the KPIs in the front-end tools. The same KPIs again need to be calculated in Snowflake. It would be very helpful if they can include some OLAP features. This will bring efficiency because we will be able to create the KPIs within Snowflake itself and then publish them to multiple front-end tools. We won't have to recreate the same in each project. There should be the ability to automate raised queries, which is currently not possible. There should also be something for Exception Aggregation and things like that.""Their UiPath, the workspace area, needs some work.""Every product has room for improvement, although in this case, it needs some broadening of the functionality.""Pricing is an issue for many customers.""The complexity of the initial setup of Snowflake depends on the use case. However, Snowflake itself, we don't set it up. The difficulty comes from the ingestion patterns, depending on what data I'm putting in, what kind of enrichment, and what additional value we have to add. However, it does tend to get complex because we have a lot of semi-structured data which we need to handle in Snowflake. There have been some challenges."

More Snowflake Cons →

"Teradata should focus on functionality for building predictive models because, in that regard, it can definitely improve.""I would like to see more integration with many different types of data.""The scalability could be better. The on-premises solution is always more complicated to scale.""It could use some more advanced analytics relating to structured and semi-structured data.""Teradata needs to pay attention to the cloud-based solution to make sure it runs smoothly.""Apart from Control-M, it would be nice if it could integrate with other tools.""I'm not sure about the unstructured data management capabilities. It could be improved.""Teradata's pricing is quite high compared to Redshift, Synapse, or GCP alternatives."

More Teradata Cons →

Pricing and Cost Advice
  • "The pricing for Snowflake is competitive."
  • "On average, with the number of queries that we run, we pay approximately $200 USD per month."
  • "Pricing is approximately $US 50 per DB. Terabyte is around $US 50 per month."
  • "The price of Snowflake is very reasonable."
  • "The price of Snowflake is quite reasonable."
  • "Its price should be improved. It should be cheaper than Microsoft."
  • "It is per credit. It has a use-it-as-you-go model. We bought a chunk of 20,000 credits, and they were lasting us for at least a year. We didn't have the scale of data like a much larger company to consume more credits. For us, it was very inexpensive. Their strategy is just to leverage what you've got and put Snowflake in the middle. It doesn't make it expensive because most of the organizations already have reporting tools. Now, if you were starting from scratch, it might be cheaper to go a different way."
  • "We used Snowflake to see if it is cheaper than using BigQuery. It was just to maintain the cost or the KPI regarding the cost of connectivity by users. Snowflake wasn't cheaper than BigQuery, and its affordability was the main issue."
  • More Snowflake Pricing and Cost Advice →

  • "The solution requires a license."
  • "The price of Teradata is on the higher side, and I think that it where they lose out on some of their business."
  • "The price of the solution could be reduced, it is expensive."
  • "Teradata is expensive, so it's typically marketed to big customers. However, there have been some changes, and Teradata is now offering more flexible pricing models and equipment leasing. They've added pay-as-you-go and cloud models, so it's changing, but Teradata is generally known as an expensive high-end product."
  • "The cost of running Teradata is quite high, but you get a good return on investment."
  • "Teradata pricing is fine, and it's competitive with all the legacy models. On a scale of one to five, with one being the worst and five being the best, I'm giving Teradata a three, because it can be a little expensive, when compared to other solutions."
  • "The price of Teradata is expensive. However, what they deliver they are outstanding. If you're looking for an inexpensive solution to run a database, this isn't your tool. It's the Ferrari of databases for data warehousing."
  • More Teradata Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
    608,010 professionals have used our research since 2012.
    Questions from the Community
    Top Answer: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.
    Top Answer:The pricing is fair for all the features that Snowflake is providing. The way Snowflake has emerged in the past few years is impressive. It was just a beginner in the space, and it has become a leader… more »
    Top Answer:Sometimes when I'm trying to refresh the data, my different application or tool has to connect to its backend database through the connection I create. Sometimes, I face some issues like not having… more »
    Top Answer:I've never had any issues with scalability.
    Top Answer:Apart from Control-M, it would be nice if it could integrate with other tools. Specifically, with respect to the integrations with the automation tools, if that can be increased, and if the tester… more »
    Top Answer:We primarily use the solution for the EDW.
    Ranking
    1st
    out of 30 in Data Warehouse
    Views
    38,560
    Comparisons
    28,984
    Reviews
    49
    Average Words per Review
    566
    Rating
    8.4
    3rd
    out of 30 in Data Warehouse
    Views
    12,526
    Comparisons
    9,991
    Reviews
    9
    Average Words per Review
    446
    Rating
    8.6
    Comparisons
    Also Known As
    Snowflake Computing
    Learn More
    Overview

    Snowflake is a fully managed SaaS (software as a service) that provides a single platform for data warehousing, data lakes, data engineering, data science, data application development, and secure sharing and consumption of real-time / shared data.

    Its platform is made up of three components:

    1. Cloud services: As part of its cloud services, Snowflake uses ANSI SQL, which empowers users to optimize their data and manage their infrastructure, while Snowflake handles the security and encryption of stored data.
    1. Query processing: With Snowflake, workload concurrency is never a problem because its compute layer is made up of virtual cloud data warehouses that let you analyze data through requests. Each of the warehouses do not compete for computing resources nor do they affect the performance of each other.
    1. Database storage: Snowflake manages all parts of the data storage process automatically, including file size, compression, organization, structure, and metadata, as well as statistics.

    Snowflake Features

    Snowflake has many valuable key features. Some of the most useful ones include:

    • Scalability: Snowflake architecture provides nearly unlimited scalability and high speed because it uses a single elastic performance engine. The solution also supports an unlimited amount of concurrent users and workloads, from interactive to batch.
    • Automation: Snowflake makes automation easy and enables enterprises to automate data management, security, governance, availability, and data resiliency.
    • Seamless cross-cloud and cross-region connections: With seamless cross-cloud and cross-region connections, Snowflake eliminates ETL and data silos. Anyone who needs access to shared secure data can get a single copy via the data cloud. In addition, Snowflake makes remote collaboration and decision-making fast and easy via a single shared data source.
    • Third-party data integrations: Snowflake’s Data Marketplace offers third-party data which allows you to connect with Snowflake customers to extend workflows with data services and third-party applications.

    Snowflake Benefits

    There are many benefits to implementing Snowflake. Some of the biggest advantages the solution offers include:

    • Helps optimize costs
    • Reduces downtime
    • Improves operational efficiency
    • Built for high reliability and availability
    • Automates data replication for fast recovery

    Reviews from Real Users

    Below are some reviews and helpful feedback written by PeerSpot users currently using the Snowflake solution.

    Sreenivasan R., Director of Data Architecture and Engineering at Decision Minds, says, "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."

    A director of business operations at a logistics company mentions, "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."

    A Solution Architect at a wholesaler/distributor comments, "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."

    Teradata's portfolio of big data analytic solutions, integrated marketing applications, and services help organizations gain a sustainable competitive advantage with data.

    Offer
    Learn more about Snowflake
    Learn more about Teradata
    Sample Customers
    Accordant Media, Adobe, Kixeye Inc., Revana, SOASTA, White Ops
    Netflix
    Top Industries
    REVIEWERS
    Computer Software Company39%
    Financial Services Firm12%
    Manufacturing Company9%
    Comms Service Provider6%
    VISITORS READING REVIEWS
    Computer Software Company26%
    Comms Service Provider13%
    Financial Services Firm10%
    Insurance Company6%
    REVIEWERS
    Comms Service Provider29%
    Financial Services Firm14%
    Computer Software Company14%
    Energy/Utilities Company14%
    VISITORS READING REVIEWS
    Computer Software Company26%
    Financial Services Firm15%
    Comms Service Provider14%
    Manufacturing Company6%
    Company Size
    REVIEWERS
    Small Business24%
    Midsize Enterprise23%
    Large Enterprise53%
    VISITORS READING REVIEWS
    Small Business17%
    Midsize Enterprise14%
    Large Enterprise70%
    REVIEWERS
    Small Business33%
    Midsize Enterprise11%
    Large Enterprise56%
    VISITORS READING REVIEWS
    Small Business12%
    Midsize Enterprise11%
    Large Enterprise76%
    Buyer's Guide
    Snowflake vs. Teradata
    May 2022
    Find out what your peers are saying about Snowflake vs. Teradata and other solutions. Updated: May 2022.
    608,010 professionals have used our research since 2012.

    Snowflake is ranked 1st in Data Warehouse with 49 reviews while Teradata is ranked 3rd in Data Warehouse with 13 reviews. Snowflake is rated 8.4, while Teradata is rated 8.6. 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 "Good performance, flexible, easy to tune queries, and scales well". Snowflake is most compared with Microsoft Azure Synapse Analytics, Amazon Redshift, Vertica, AWS Lake Formation and Oracle Exadata, whereas Teradata is most compared with Oracle Exadata, SQL Server, Vertica, MySQL and Microsoft Azure Synapse Analytics. See our Snowflake vs. Teradata report.

    See our list of best 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.