Snowflake Analytics vs Teradata comparison

Cancel
You must select at least 2 products to compare!
Snowflake Computing Logo
493 views|330 comparisons
100% willing to recommend
Teradata Logo
5,898 views|4,926 comparisons
87% willing to recommend
Comparison Buyer's Guide
Executive Summary

We performed a comparison between Snowflake Analytics and Teradata 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.
To learn more, read our detailed Snowflake Analytics vs. Teradata Report (Updated: March 2024).
770,292 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
"It's a scalable solution because you can analyze a huge amount of data in the solution.""I am impressed with the product's data-sharing feature.""It is quite a convenient tool.""Considering everything I have accessed, the product's dashboard is good since it provides multiple good options, including customization options.""It ensures the optimization of the application development while maintaining the user-friendly nature of its UI.""Its performance speed is very good.""The platform not only provides ease of use but also stands out for its speedy execution, conveying a sense of robustness and reliability that I find appealing.""Snowflake Analytics is pretty easy to use with the connectors for integration with the tools and systems in my company."

More Snowflake Analytics Pros →

"It has massive parallel processing ability to do large amounts of concurrent querying.""When it comes to integration, tools like Informatica seamlessly connect with Teradata. We ensure the Teradata database is configured correctly in Informatica, including the proper hostname and properties for the load process. We didn't find any major complexity or issues with integration.""Teradata's pretty fast.""The ability to handle machine data parallel processing is the most valuable feature of Teradata.""It effectively has allowed us to remove over 20 portion copies of the data sets on other DB platforms for real-time operational reporting purposes.""We did performance testing. We had a set of real life MicroStrategy reports. Our conditions were: Not allowed to redesign data model, not allowed to rewrite the queries, all queries should be generated by MicroStrategy, no aggregates. Teradata appeared to be way faster than a similarly configured (in terms of hardware) Oracle server.""It has a solid set of tools and consulting services.""Improved performance of ETL procedures, reporting."

More Teradata Pros →

Cons
"Machine learning in Snowflake isn't as advanced as in other products. I haven't heard of any successful industry-wide use cases of machine learning implemented in Snowflake. It might take a couple of years to reach the same level as Databricks.""The UI must be improved.""The distribution methodology isn't as strong as Bethesda or SAP HANA. It's not as strong as other competitors.""I cannot comment on the product's stability because we are still struggling with its performance.""A room for improvement in Snowflake Analytics is Spark, particularly its connector for Spark. An additional feature I'd like to see in the next release of the solution is built-in analytics.""The tool should support EIM use cases. I guess the product is already working on it. I look forward to seeing inbuilt AI generative tools in the solution's future releases. The tool's price can be a little lower. The solution's on-premises support is also very limited. We have to rely on other support services to deploy it on-premises.""Machine learning should be improved.""Moving data from legacy systems to Snowflake is not that easy. There are some cases where processors are not actually compatible with Snowflake."

More Snowflake Analytics Cons →

"Teradata should focus on functionality for building predictive models because, in that regard, it can definitely improve.""The cloud is the new challenge and the new opportunity.""The current operational approach needs improvement.""The user interface needs to be improved.""The scalability could be better. The on-premises solution is always more complicated to scale.""Teradata needs to pay attention to the cloud-based solution to make sure it runs smoothly.""​I think the UI is not there yet. It could be improved by being more user-friendly.​""Data ingestion is done via external utilities and not by the query language itself. It would be more convenient to have that functionality within its SQL dialect."

More Teradata Cons →

Pricing and Cost Advice
  • "Snowflake Analytics is a little more costly than Azure."
  • "When using Snowflake, you pay based on your usage. They calculate how much CPU has been used. If you use excess warehouse storage, you are charged one credit per hour. If you are in Asia, you are charged $3 per credit. If you have 10 users running parallel with the same excess, you will be charged $30."
  • "The cost of Snowflake Analytics is low, any small organization can use it."
  • "The solution's price is high and I would rate it an eight out of ten."
  • "On a scale of one to ten, where one is a low price, and ten is a high price, I rate the pricing a seven. The solution's pricing is high."
  • "It is an expensive solution, but the kind of usability and flexibility it proactively provides for the organizations justify the price."
  • "The tool is quite expensive."
  • "Snowflake Analytics is not an expensive solution, and its pricing is average."
  • More Snowflake Analytics Pricing and Cost Advice →

  • "Teradata is not cheap, but you get what you pay for."
  • "Make sure you have the in-house skills to design and support the solution, as relying on external sources is extremely costly and tends to lock you into specific platforms, tools, and paradigms."
  • "In the past, it turned out that other solutions, in order to provide the full range of abilities that the Teradata platform provides plus the migration costs, would end up costing more than Teradata does."
  • "The initial cost may seem high, but the TCO is low."
  • "Teradata is currently making improvements in this area."
  • "It is still a very expensive solution. While I very much like the pure technological supremacy of the software itself, I believe Teradata as a company needs to become more affordable. They are already losing the market to more flexible or cheaper competitors."
  • "Teradata is expensive but gives value for money, especially if you don't want to move your data to the cloud."
  • "Price is quite high, so if it is really possible to use other solutions (e.g. you do not have strict requirements for performance and huge data volumes), it might be better to look at alternatives from the RDBMS world."
  • More Teradata Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
    770,292 professionals have used our research since 2012.
    Comparison Review
    Anonymous User
    Questions from the Community
    Top Answer:The Snowflake features I find most beneficial for data analysis are primarily related to analytics, particularly their features like materialized views and queues, which are especially useful for… more »
    Top Answer:The pricing is on the higher side. I would rate it seven out of ten.
    Top Answer:The scheduling of jobs requires improvement, particularly in terms of the user interface which currently lacks certain features found in comparable platforms.
    Top Answer: I have spoken to my colleagues about this comparison and in our collective opinion, the reason why some people may declare Teradata better than Oracle is the pricing. Both solutions are quite… more »
    Top Answer: Before my organization implemented this solution, we researched which big brands were using Teradata, so we knew if it would be compatible with our field. According to the product's site, the… more »
    Top Answer:Teradata is not a difficult product to work with, especially since they offer you technical support at all levels if you just ask. There are some features that may cause difficulties - for example… more »
    Ranking
    6th
    Views
    493
    Comparisons
    330
    Reviews
    30
    Average Words per Review
    486
    Rating
    8.4
    3rd
    out of 35 in Data Warehouse
    Views
    5,898
    Comparisons
    4,926
    Reviews
    21
    Average Words per Review
    469
    Rating
    7.8
    Comparisons
    SQL Server logo
    Compared 19% of the time.
    Snowflake logo
    Compared 12% of the time.
    Oracle Exadata logo
    Compared 11% of the time.
    MySQL logo
    Compared 10% of the time.
    BigQuery logo
    Compared 7% of the time.
    Learn More
    Overview

    Conventional data platforms and big data solutions struggle to deliver on their fundamental purpose: to enable any user to work with any data, without limits on scale, performance or flexibility. Whether you’re a data analyst, data scientist, data engineer, or any other business or technology professional, you’ll get more from your data with Snowflake.

    To achieve this, we built a new data platform from the ground up for the cloud. It’s designed with a patented new architecture to be the centerpiece for data pipelines, data warehousing, data lakes, data application development, and for building data exchanges to easily and securely share governed data. The result, A platform delivered as a service that’s powerful but simple to use.

    Snowflake’s cloud data platform supports a multi-cloud strategy, including a cross-cloud approach to mix and match clouds as you see fit. Snowflake delivers advantages such as global data replication, which means you can move your data to any cloud in any region, without having to re-code your applications or learn new skills.

    Teradata is a multi-cloud data platform company that provides data warehouse and relational database tools. The brand has an extensive portfolio of big data analytic solutions, integrated marketing applications, and services. The products that Teradata offers can be categorized in the following ways:

    • Software: The products in this category include Teradata Vantage, an advanced SQL engine and Teradata database.

    • Cloud: The solutions can work with popular cloud services such as Amazon AWS, Microsoft Azure, Google Cloud Platform, and VMware. Teradata Cloud and customer cloud are also included in this product category.

    • Ecosystem management: The products in this section include IntelliSphere, business continuity manager, data lab, data mover, data stream, QueryGrid, and viewpoint.

    • Hardware: This category includes backup, archive, and restore (BAR) and IntelliFlex.

    • Applications: Master data management (MDM) and Teradata analytics for enterprise applications are the two products in this category.

    One of the most popular and commonly used products by Teradata is Teradata Vantage. This is a connected multi-cloud data platform for enterprise analytics. The product unifies data lakes, analytics, and data warehouses, as well as data sources and types. The solution offers its customers scalability, which allows them to scale dimensions to handle massive workloads of data. Teradata Vantage utilizes artificial intelligence (AI) and machine learning (ML) to power more models and enhance quality.

    Through Vantage Console, businesses can benefit from role-based, no-code software to organize and manage their data. The product offers deployment on many popular public clouds, on premises, and on commodity hardware. Teradata Vantage unifies and integrates all data types from sources and provides companies with a single source of information. It achieves this by supporting all common data types and formats. The product also provides organizations with tools for monitoring, analyzing, and connecting data throughout the organizations.

    Part of this product is also VantageCloud, which offers a modern cloud-native architecture as well as hybrid and multi-cloud deployment options. This solution offers new ways for clients to deploy their platforms. These include the next-generation, cloud-native architecture of Teradata VantageCloud Lake.

    Teradata Features

    The different products that Teradata offers have various features which facilitate data management for customers. Some of the key capabilities of the solutions offered by Teradata include:

    • Connectivity: Users can benefit from connections to the mainframe or network-attached systems. The product provides its own extension for interaction with data stored in the tables. It also supports SQL.

    • Linear scalability: Teradata solutions are highly scalable and linear. The solution can handle large volumes of data effectively while also supporting the ability to scale up to 2048 nodes.

    • Load and unload utilities: The product offers features to move data in and out of the product's system effectively.

    • Mature optimizer: Part of this feature is Teradata Optimizer, which is an advanced product that can handle up to 64 joins in a single query.

    • Robust utilities: The solution includes multiple robust utilities in this category of features that facilitate data handling in and out of the product's systems. The tools include MultiLoad, FastLoad, and FastExport.

    • Shared nothing architecture: This set of features, connected to the architecture of Teradata, is known as “shared nothing architecture” because the nodes, processors, and disks all work independently. These capacities ensure better value for a given task.

    • Unlimited parallelism: These features divide large volumes of data into smaller processes that are executed in parallel. This contributes to the execution of complex tasks in a timely manner.

    Teradata Benefits

    Through its multiple solutions, Teradata offers various benefits for its clients. Some of these include:

    • The solution facilitates prototype creation and offers faster times for completion.

    • Through Teradata, users are able to use faster, simpler, and easier solutions for data-related tasks.

    • The product eliminates the need for unnecessary data movement, which contributes to performance improvements.

    • Teradata offers developers the ability to decide where in the architecture different parts of an application run.

    • Teradata allows database administrators to manage databases from a single point of control.

    • The solution provides the option to get the same data on multiple deployment options.

    • The product supports Online Analytical Programming (OLAP) functions, which allows it to perform a complex analytical process of data.

    • Teradata uses the Service Workstation to provide a single operation view for the multi-node system of the product.

    Reviews from Real Users

    Martin P., a services manager at Bytes Systems Integration, describes Teradata as a product that is very fast with good database control and excellent support.

    Blaine V., principal at Insight Data Consulting, rates Teradata highly because of its excellent native features, highly stable, and impressive automation.

    Sample Customers
    Lionsgate, Adobe, Sony, Capital One, Akamai, Deliveroo, Snagajob, Logitech, University of Notre Dame, Runkeeper
    Netflix
    Top Industries
    REVIEWERS
    Computer Software Company31%
    Financial Services Firm31%
    Outsourcing Company15%
    Retailer8%
    VISITORS READING REVIEWS
    Computer Software Company17%
    Financial Services Firm9%
    Manufacturing Company9%
    Retailer8%
    REVIEWERS
    Comms Service Provider26%
    Computer Software Company22%
    Financial Services Firm9%
    Energy/Utilities Company9%
    VISITORS READING REVIEWS
    Financial Services Firm26%
    Computer Software Company10%
    Manufacturing Company8%
    Healthcare Company7%
    Company Size
    REVIEWERS
    Small Business22%
    Midsize Enterprise25%
    Large Enterprise53%
    VISITORS READING REVIEWS
    Small Business20%
    Midsize Enterprise18%
    Large Enterprise63%
    REVIEWERS
    Small Business33%
    Midsize Enterprise11%
    Large Enterprise56%
    VISITORS READING REVIEWS
    Small Business14%
    Midsize Enterprise9%
    Large Enterprise77%
    Buyer's Guide
    Snowflake Analytics vs. Teradata
    March 2024
    Find out what your peers are saying about Snowflake Analytics vs. Teradata and other solutions. Updated: March 2024.
    770,292 professionals have used our research since 2012.

    Snowflake Analytics is ranked 6th in Cloud Data Warehouse with 30 reviews while Teradata is ranked 3rd in Data Warehouse with 54 reviews. Snowflake Analytics is rated 8.4, while Teradata is rated 8.2. The top reviewer of Snowflake Analytics writes "A scalable tool useful for data lake and data mining processes". On the other hand, the top reviewer of Teradata writes "Offers seamless integration capabilities and performance optimization features, including extensive indexing and advanced tuning capabilities". Snowflake Analytics is most compared with Azure Data Factory, Adobe Analytics, Mixpanel, Amplitude and Glassbox, whereas Teradata is most compared with SQL Server, Snowflake, Oracle Exadata, MySQL and BigQuery. See our Snowflake Analytics vs. Teradata report.

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