

Teradata and Dremio compete in the data warehousing and analytics space. Teradata appears to have the upper hand in speed and efficiency with massive data processing, whereas Dremio offers superior flexibility and integration capabilities.
Features: Teradata is renowned for its capability to manage massive parallel processing and handle complex queries swiftly and efficiently. Its shared-nothing architecture and scalability enable easy data migration and large data set processing. Dremio stands out in providing a flexible, federated query approach that integrates well with various data sources, showcasing strengths in data cataloging and visualization.
Room for Improvement: Teradata could reduce its high costs, streamline setup processes, and enhance integration capabilities with cloud-based solutions. It also needs improvements in handling unstructured data and scalability. Dremio requires enhancements in query performance for complex queries and improved community support. Enhancing data connectors could further leverage its integration potential.
Ease of Deployment and Customer Service: Teradata offers a robust mix of deployment options, including on-premises and cloud, with reliable support, although response times vary. Dremio, appreciated for its easier deployment on hybrid and public clouds, faces challenges with community engagement and support consistency.
Pricing and ROI: Teradata, though critiqued for high costs, delivers significant ROI especially in large-scale projects, with recommendations to negotiate pricing models. Dremio offers a more cost-effective solution compared to some competitors, yet licensing for scaling presents challenges. Teradata achieves robust ROI through performance, while Dremio offers affordable solutions but faces licensing hurdles.
Dremio surely saves time, reduces costs, and all those things because we don't have to worry so much about the infrastructure to make the different tools communicate.
At least fifteen to twenty percent of our time has been saved using Teradata, which has positively affected team productivity and business outcomes.
Independent research showed that Teradata VantageCloud users achieved an average ROI of 427% across three years with payback under a year, demonstrating the platform's ability to deliver a strong financial return.
We have realized a return on investment, with a reduction of staff from 27 to eight, and our current return on investment is approximately 14%.
I would rate customer support a ten out of ten.
We contact the technical support at least weekly; currently, it's more or less daily because we face performance issues, crashes of queries sometimes, and we also need support for configuration of the query engines and so on.
We have had to reach out for customer support many times, and they respond, so they are pretty supportive about some long-term issues.
The customer support for Teradata has been great.
They are responsive and knowledgeable, and the documentation is very helpful.
Teradata's customer support was excellent.
Dremio's scalability can handle growing data and user demands easily.
Internally, if it's on Docker or Kubernetes, scalability will be built into the system.
Dremio's scalability depends on your hardware and your deployment.
Whenever we need more resources, we can add that in Teradata, and when not needed, we can scale it down as well.
This flexibility allows organizations to scale according to their needs, balancing performance, cost, and compliance requirements.
The scalability of Teradata is flawless.
I rate Dremio a nine in terms of stability.
We refactored the query, and that worked, but it still doesn't make you confident to go to production with a product that might crash depending on the query you send it.
Its massively parallel process architecture allows the platform to distribute workload efficiently, enabling organizations to run heavy analytic queries without compromising speed or stability.
Teradata is stable.
Starburst comes with around 50 connectors now.
Before we wrap up, I want to add that Dremio is lacking a semantic layer in a manner that the user can just choose dimensions, metrics, and filters to query the data.
It should be easier to get Arctic or an open-source version of Arctic onto the software version so that development teams can experiment with it.
I want to highlight two features for improvement: first, storing data in various formats without requiring a tabular structure, accommodating unstructured data; and second, adding AI ML features to better integrate Gen AI, LLM concepts, and user-friendly experiences such as text-to-SQL capabilities.
The most challenging aspect is finding Teradata resources, so we are focusing on internal training and looking for more Teradata experts.
If the same thing were available in a web interface, that would be really helpful.
I chose eight out of ten because Dremio is expensive for the Enterprise version, particularly regarding licensing.
I had a good experience with pricing, as the pricing seems okay to me and the client.
Dremio does have a core of the engine that is open-source, but all the important features for the enterprise version are under license.
Role-based access control (RBAC), strong audit and compliance features, high availability, fault tolerance, and encrypted data at rest and in-transit are key features.
We spent roughly $295,000 on setup costs.
I found Teradata to be somewhat costlier when considering other options.
Having everything under one system and an easier-to-work-with interface, along with having API integrations, adds significant value to working with Dremio.
Dremio has positively impacted my organization as nowadays we are connected to multiple databases from multiple environments, multiple APIs, and applications, and Dremio organizes everything in an amazing way for me.
Multiple data sources can be queried in one query, and it is not just a query engine.
Teradata's security helps our organization meet compliance requirements such as GDPR and IFRS, and it is particularly essential for revenue contracting or revenue recognition.
Its architecture allows information to be processed efficiently while maintaining stable performance, even in highly demanding environments.
It facilitates data integration, where we integrate and analyze data from various sources, making it a powerful and high-quality reliable solution for the company.
| Product | Mindshare (%) |
|---|---|
| Teradata | 9.2% |
| Dremio | 4.3% |
| Other | 86.5% |


| Company Size | Count |
|---|---|
| Small Business | 3 |
| Midsize Enterprise | 6 |
| Large Enterprise | 5 |
| Company Size | Count |
|---|---|
| Small Business | 28 |
| Midsize Enterprise | 13 |
| Large Enterprise | 53 |
Dremio offers a comprehensive platform for data warehousing and data engineering, integrating seamlessly with data storage systems like Amazon S3 and Azure. Its main features include scalability, query federation, and data reflection.
Dremio's core strength lies in its ability to function as a robust data lake query engine and data warehousing solution. It facilitates the creation of complex queries with ease, thanks to its support for Apache Airflow and query federation across endpoints. Despite challenges with Delta connector support, complex query execution, and expensive licensing, users find it valuable for managing ad-hoc queries and financial data analytics. The platform aids in SQL table management and BI traffic visualization while reducing storage costs and resolving storage conflicts typical in traditional data warehouses.
What are Dremio's most valuable features?Dremio is primarily implemented in industries requiring extensive data engineering and analytics, including finance and technology. Companies use it for constructing data frameworks, efficiently processing financial analytics, and visualizing BI traffic. It acts as a viable alternative to AWS Glue and Apache Hive, integrating seamlessly with multiple databases, including Oracle and MySQL, offering robust solutions for data-driven strategies. Despite some challenges, its ability to reduce data storage costs and manage complex queries makes it a favorable choice among enterprise users.
Teradata is a powerful tool for handling substantial data volumes with its parallel processing architecture, supporting both cloud and on-premise environments efficiently. It offers impressive capabilities for fast query processing, data integration, and real-time reporting, making it suitable for diverse industrial applications.
Known for its robust parallel processing capabilities, Teradata effectively manages large datasets and provides adaptable deployment across cloud and on-premise setups. It enhances performance and scalability with features like advanced query tuning, workload management, and strong security. Users appreciate its ease of use and automation features which support real-time data reporting. The optimizer and intelligent partitioning help improve query speed and efficiency, while multi-temperature data management optimizes data handling.
What are the key features of Teradata?
What benefits and ROI do users look for?
In the finance, retail, and government sectors, Teradata is employed for data warehousing, business intelligence, and analytical processing. It handles vast datasets for activities like customer behavior modeling and enterprise data integration. Supporting efficient reporting and analytics, Teradata enhances data storage and processing, whether deployed on-premise or on cloud platforms.
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.