Snowflake vs Teradata IntelliFlex comparison

Cancel
You must select at least 2 products to compare!
Snowflake Computing Logo
12,290 views|6,971 comparisons
96% willing to recommend
Teradata Logo
493 views|302 comparisons
100% willing to recommend
Comparison Buyer's Guide
Executive Summary

We performed a comparison between Snowflake and Teradata IntelliFlex based on real PeerSpot user reviews.

Find out in this report how the two Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.
To learn more, read our detailed Snowflake vs. Teradata IntelliFlex Report (Updated: March 2024).
767,847 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
"I have found the solution's most valuable features to be storage, flexibility, ease of use, and security.""Everything is automatic, and I don't have to do any maintenance.""From a data warehouse perspective, it's an excellent all-round solution. It's very complete.""It was relatively easy to use, and it was easy for people to convert to it.""The most valuable feature is the clone copy.""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.""Its speed and performance were the most valuable. Easy configuration of Snowflake in any cloud was also a benefit.""The ETL and data ingestion capabilities are better in this solution as compared to SQL Server. SQL Server doesn't do much data ingestion, but Snowflake can do it quite conveniently."

More Snowflake Pros →

"It is very stable. It's 100% uptime. Speed and resilience are one of the greatest features of this product. In almost twenty years we've never had downtime, except for outages for patches and upgrades. We've never had a system failure in twenty years.""The solution's banking model, called FSLDM (Financial Services Logical Data Model), is sophisticated and good.""IntelliFlex is easy to scale - one of its best features is that you can upscale it to the size you want.""The product's scalability is great. Scalability-wise, I rate the solution a ten out of ten.""Intelliflex is very scalable. In fact, scalability has improved 100 times by Intelliflex, in my personal opinion."

More Teradata IntelliFlex Pros →

Cons
"There are some challenges with loading unstructured data and integrating some message queues or brokers. In one project, we had a problem connecting to one of the message queues and we had to take a different route altogether on Microsoft Azure.""We are yet to figure out how to integrate tools, such as Liquibase, to release changes to our data warehouse model.""The cost efficiency and monitoring of this solution could be improved. It's easy to spend a lot on Snowflake and it does offer monitoring tools but they're pretty basic.""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.""I have heard people having difficulty with the machine learning model, so there may be room for improvement.""This solution could be improved by offering machine learning apps.""I see room for improvement when it comes to credit performance. The other thing I'd like to be improved is the warehouse facility.""The pricing of the solution should be much easier to calculate or find by yourself."

More Snowflake Cons →

"The reporting side wasn't very good in the past, but with the latest versions, it's getting better. Still, the friendliness of the PDC reporting and functionality needs to be improved.""They should add more connectors to different platforms.""The initial setup is complex because there are a lot of factors that come into play, including the amount of software and applications that require access.""The only issue our company has with Teradata IntelliFlex is that it is not cost-effective because of the way the product has been designed.""The solution’s pricing, scalability, and technical support response time could be improved."

More Teradata IntelliFlex Cons →

Pricing and Cost Advice
  • "Pricing can be confusing for customers."
  • "The whole licensing system is based on credit points. You can also make a license agreement with the company so that you buy credit points and then you use them. What you do not use in one year can be carried over to the next year."
  • "You pay based on the data that you are storing in the data warehouse and there are no maintenance costs."
  • "It is not cheap."
  • "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."
  • More Snowflake Pricing and Cost Advice →

  • "Users have to pay a yearly licensing fee for Teradata IntelliFlex, which is very expensive."
  • More Teradata IntelliFlex Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
    767,847 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:The best thing about Snowflake is its flexibility in changing warehouse sizes or computational power.
    Top Answer:The real-time streaming feature is limited with Snowflake and could be improved. Currently, Snowflake doesn't support unstructured data. With Snowflake, you need to be very particular about the type… more »
    Top Answer:The solution's banking model, called FSLDM (Financial Services Logical Data Model), is sophisticated and good.
    Top Answer:The solution’s pricing, scalability, and technical support response time could be improved.
    Top Answer:We use Teradata IntelliFlex for data warehousing, which is a way of presenting data for faster retrieval.
    Ranking
    1st
    out of 34 in Data Warehouse
    Views
    12,290
    Comparisons
    6,971
    Reviews
    36
    Average Words per Review
    464
    Rating
    8.3
    11th
    out of 34 in Data Warehouse
    Views
    493
    Comparisons
    302
    Reviews
    3
    Average Words per Review
    606
    Rating
    8.3
    Comparisons
    Also Known As
    Snowflake Computing
    Learn More
    Overview

    Snowflake is a cloud-based data warehousing solution for storing and processing data, generating reports and dashboards, and as a BI reporting source. It is used for optimizing costs and using financial data, as well as for migrating data from on-premises to the cloud. The solution is often used as a centralized data warehouse, combining data from multiple sources.

    Snowflake has helped organizations improve query performance, store and process JSON and XML, consolidate multiple databases into one unified table, power company-wide dashboards, increase productivity, reduce processing time, and have easy maintenance with good technical support.

    Its platform is made up of three components:

    1. Cloud services - Snowflake uses ANSI SQL to empower users to optimize their data and manage their infrastructure, while Snowflake handles the security and encryption of stored data.
    2. Query processing - Snowflake's compute layer is made up of virtual cloud data warehouses that let you analyze data through requests. Each of the warehouses does not compete for computing resources, nor do they affect the performance of each other.
    3. Database storage - Snowflake automatically manages all parts of the data storage process, including file size, compression, organization, structure, metadata, and statistics.

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

    • Snowflake architecture provides nearly unlimited scalability and high speed because it uses a single elastic performance engine. The solution also supports unlimited concurrent users and workloads, from interactive to batch.
    • Snowflake makes automation easy and enables enterprises to automate data management, security, governance, availability, and data resiliency.
    • 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.
    • 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.

    There are many benefits to implementing Snowflake. It helps optimize costs, reduce downtime, improve operational efficiency, and automate data replication for fast recovery, and it is built for high reliability and availability.

      Below are quotes from interviews we conducted with 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 computing is another big feature. Separating computing and storage gives you flexibility. It doesn't require much DBA involvement because it doesn't need any performance tuning. We are not doing any performance tuning, and the entire burden of performance 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 IntelliFlex delivers real-time intelligence to place vital data into the hands of front-line decision makers, while extending traditional data warehouse functionality into the realm of tactical decision making. With IntelliFlex, you can combine both these strategic and operational workloads in a single data warehouse.

      Sample Customers
      Accordant Media, Adobe, Kixeye Inc., Revana, SOASTA, White Ops
      Information Not Available
      Top Industries
      REVIEWERS
      Computer Software Company29%
      Financial Services Firm20%
      Healthcare Company6%
      Manufacturing Company6%
      VISITORS READING REVIEWS
      Educational Organization26%
      Financial Services Firm13%
      Computer Software Company10%
      Manufacturing Company6%
      VISITORS READING REVIEWS
      Financial Services Firm28%
      Computer Software Company16%
      Manufacturing Company9%
      Retailer8%
      Company Size
      REVIEWERS
      Small Business24%
      Midsize Enterprise20%
      Large Enterprise55%
      VISITORS READING REVIEWS
      Small Business15%
      Midsize Enterprise34%
      Large Enterprise52%
      VISITORS READING REVIEWS
      Small Business11%
      Midsize Enterprise6%
      Large Enterprise83%
      Buyer's Guide
      Snowflake vs. Teradata IntelliFlex
      March 2024
      Find out what your peers are saying about Snowflake vs. Teradata IntelliFlex and other solutions. Updated: March 2024.
      767,847 professionals have used our research since 2012.

      Snowflake is ranked 1st in Data Warehouse with 92 reviews while Teradata IntelliFlex is ranked 11th in Data Warehouse with 5 reviews. Snowflake is rated 8.4, while Teradata IntelliFlex is rated 8.8. 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 IntelliFlex writes "A tool that provides high performance and speed to its users, along with an exceptional scalability option". Snowflake is most compared with BigQuery, Azure Data Factory, Teradata, Vertica and AWS Lake Formation, whereas Teradata IntelliFlex is most compared with Teradata and Oracle Exadata. See our Snowflake vs. Teradata IntelliFlex 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.