Coming October 25: PeerSpot Awards will be announced! Learn more
Cancel
You must select at least 2 products to compare!
Snowflake Computing Logo
39,888 views|29,425 comparisons
Teradata Logo
12,817 views|10,356 comparisons
Comparison Buyer's Guide
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: August 2022).
632,611 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
"Its performance is most valuable. As compared to SQL Server, we are able to see a significant improvement in performance with Snowflake.""Snowflake is an enormously useful platform. The Snowpipe feature is valuable because it allows us to load terabytes and petabytes of data into the data mart at a very low cost.""It's ultra-fast at handling queries, which is what we find very convenient.""I like Snowflake's data exchange capabilities. It can exchange data with downstream systems and other vendor partners as well.""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.""The adaptation to development languages is most valuable. Our developers can SQL code or something else. It has been convenient in that regard.""The technical support is pretty good, particularly if you are a more technical user.""The most efficient way for real-time dashboards or analytical business intelligence reports to be sent to the customer."

More Snowflake Pros →

"The functionality of the solution is excellent.""The most valuable feature of Teradata is security. It runs on Unix and Linux platforms which provide better security.""It's very, very fast""Teradata can be deployed on-premise, on the cloud, or in a virtual machine, which means customers can move without having to create their architecture all over again.""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 flexibility in design is very good.""Teradata features high productivity and reliability because it has several redundancy options, so the system is always up and running.""The performance is great, we are able to query our data in one operation."

More Teradata Pros →

Cons
"There are always a few operation updates here and there that can be made.""It's not that flexible when compared to Oracle.""The solution could use a little bit more UI.""The solution needs more connectors.""Product activation queries can't be changed while executing.""I would like to see a client version of the GUI.""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.""An additional feature I'd like to see is called materialized views, which can speed up some run times. I'd like it to be able to be used where you can have multiple tables inside them; materialized view. That would be nice. As well as being able to run cursors, to be able to do some bulk updates and some more advanced querying, table building on the fly."

More Snowflake Cons →

"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.""It could use some more advanced analytics relating to structured and semi-structured data.""Teradata needs to expand the kind of training that's available to customers. Teradata only offers training directly and doesn't delegate to any third-party companies. As a result, it's harder to find people trained on Teradata in our market relative to Oracle.""Teradata needs to pay attention to the cloud-based solution to make sure it runs smoothly.""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.""The solution is stable. However, there are times when we are using large amounts of data and we can see some latency issues.""Teradata's UI could be more user-friendly."

More Teradata Cons →

Pricing and Cost Advice
  • "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."
  • "Currently, we have a trial account, so we don't need a license. After our project starts, we would need a permanent license."
  • 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."
  • "The price of Teradata could be less expensive."
  • More Teradata Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
    632,611 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:The most valuable feature is the clone copy.
    Top Answer:They have different pricing structures based on data usage. I think they have three or four tiers you can scale through. Most of the clients see an advantage from this type of licensing. That's the… more »
    Top Answer:In a future release we would like to have a link which would allow us to connect to an external database and create certain views in your own database. This is because it is becoming hard for us to… more »
    Top Answer:Any value this product provides is offset by the high cost and lack of scalability. We're moving to Snowflake because of the scalability and cost differentials. There are better, more flexible… more »
    Top Answer:Our use case is for data warehousing and BI reporting. We are customers of Teradata.
    Ranking
    1st
    out of 30 in Data Warehouse
    Views
    39,888
    Comparisons
    29,425
    Reviews
    48
    Average Words per Review
    557
    Rating
    8.4
    3rd
    out of 30 in Data Warehouse
    Views
    12,817
    Comparisons
    10,356
    Reviews
    14
    Average Words per Review
    481
    Rating
    8.2
    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 Company36%
    Financial Services Firm12%
    Manufacturing Company9%
    Healthcare Company6%
    VISITORS READING REVIEWS
    Computer Software Company19%
    Financial Services Firm12%
    Comms Service Provider10%
    Insurance Company6%
    REVIEWERS
    Comms Service Provider27%
    Computer Software Company20%
    Financial Services Firm13%
    Energy/Utilities Company13%
    VISITORS READING REVIEWS
    Financial Services Firm19%
    Computer Software Company19%
    Comms Service Provider11%
    Energy/Utilities Company6%
    Company Size
    REVIEWERS
    Small Business23%
    Midsize Enterprise22%
    Large Enterprise55%
    VISITORS READING REVIEWS
    Small Business17%
    Midsize Enterprise14%
    Large Enterprise69%
    REVIEWERS
    Small Business35%
    Midsize Enterprise10%
    Large Enterprise55%
    VISITORS READING REVIEWS
    Small Business13%
    Midsize Enterprise10%
    Large Enterprise77%
    Buyer's Guide
    Snowflake vs. Teradata
    August 2022
    Find out what your peers are saying about Snowflake vs. Teradata and other solutions. Updated: August 2022.
    632,611 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 16 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 "Very fast with good database control and excellent support". 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, Microsoft Azure Synapse Analytics and MySQL. 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.