Amazon Redshift vs Dremio comparison

Read 11 Dremio reviews

4,145 Views
2,238 Comparison Views

100% willing to recommend

Amazon Redshift

Comparison Buyer's Guide

Download the report

Executive SummaryUpdated on Feb 15, 2026

Amazon Redshift and Dremio both compete in the data management platform category. Amazon Redshift has an advantage in handling petabyte-scale data with high performance through Massively Parallel Processing, while Dremio excels in data integration and governance features.

Features: Amazon Redshift's scalability is highlighted by its ability to manage petabyte-scale data and support multiple file formats, enhancing its versatility for large-scale operations. It also benefits from Massively Parallel Processing for high-performance data handling. Dremio distinguishes itself by providing a unified data access and virtualization pane, efficient data source integration, and strong data lineage and transformation tools vital for governance and compliance.

Room for Improvement: Amazon Redshift could improve in snapshot restoration times, AWS IAM integration, and query optimizations. Notable issues include challenges with vacuum processes and data migrations. Dremio faces difficulties with its Delta connector support and needs to enhance large query execution speed. Users have also pointed out the necessity for better documentation and integration capabilities.

Ease of Deployment and Customer Service: Amazon Redshift is easy to deploy on the public cloud but offers limited flexibility for hybrid environments. Its customer service, although well-regarded, typically requires a paid plan for adequate technical support. Dremio provides versatile deployment options, accommodating public, hybrid, and on-premises settings, with reliable customer service that follows a similar paid plan model as Amazon Redshift.

Pricing and ROI: Amazon Redshift is cost-effective for large-scale data needs, with potential cost increases due to complex configurations. The pay-as-you-use model is practical, showing a good ROI when transitioning from on-premises systems. While Dremio's initial cost might be higher, it reflects its data integration value, offering substantial ROI in data governance-focused environments.

To learn more, read our detailed Amazon Redshift vs. Dremio Report (Updated: April 2026).

Amazon Redshift vs. Dremio

April 2026

Download the complete report

Helped 893,221 peers since 2012

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

ROI

Sentiment score

6.0

Some entities quickly achieved cost savings and ROI, while others face challenges with optimization and evaluating benefits.

Sentiment score

5.6

Dremio reduces manpower costs, enhances efficiency, and eliminates infrastructure concerns, improving operations by accessing multiple data sources.

We earned back our investment in Amazon Redshift within the first year.

For more quotes and insights, download the Amazon Redshift report

Data engineer at a tech vendor with 10,001+ employees

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.

For more quotes and insights, download the Dremio report

SR BI developer at BRQ Digital Solutions

Customer Service

Sentiment score

6.8

Amazon Redshift support is efficient yet costly, praised for documentation, but phone contact and complex issue resolution face delays.

Sentiment score

5.2

Dremio's customer service is responsive and helpful, facing staffing challenges as demand grows, requiring more integrators for support.

Whenever we need support, if there is an issue accessing stored data due to regional data center problems, the Amazon team is very helpful and provides optimal solutions quickly.

Pavan Kum

Analyst at Cepstrum(EEE Students Society), IIT Guwahati

Documentation that allows anyone with prior knowledge of Redshift or SQL to resolve technical issues.

For more quotes and insights, download the Amazon Redshift report

Data engineer at a tech vendor with 10,001+ employees

It's costly when you enable support.

RiteshPurbey

Senior Analyst at ESRI INDIA

We have had to reach out for customer support many times, and they respond, so they are pretty supportive about some long-term issues.

For more quotes and insights, download the Dremio report

SR BI developer at BRQ Digital Solutions

Scalability Issues

Sentiment score

7.3

Amazon Redshift is highly scalable with flexible cluster adjustments, despite some challenges at larger scales and heavy loads.

Sentiment score

7.1

Dremio scales well, offering flexibility and built-in capabilities, though community users face scaling limits due to licensing.

The scalability part needs improvement as the sizing requires trial and error.

Data Analytics, Ai & Automation Lead at a venture capital & private equity firm with 10,001+ employees

We have successfully increased our storage space, which was a smooth process without server crashes before or after scaling.

For more quotes and insights, download the Amazon Redshift report

Data engineer at a tech vendor with 10,001+ employees

Dremio's scalability can handle growing data and user demands easily.

For more quotes and insights, download the Dremio report

SR BI developer at BRQ Digital Solutions

Internally, if it's on Docker or Kubernetes, scalability will be built into the system.

KamleshPant

Senior Software Architect at USEReady

Stability Issues

Sentiment score

7.3

Opinions on Amazon Redshift's stability vary, with some praising reliability and others noting issues in large clusters or maintenance.

Sentiment score

7.2

Dremio is generally stable, scoring high ratings with occasional performance issues, especially with large datasets, requiring maintenance restarts.

Amazon Redshift is a stable product, and I would rate it nine or ten out of ten for stability.

For more quotes and insights, download the Amazon Redshift report

Data Analytics, Ai & Automation Lead at a venture capital & private equity firm with 10,001+ employees

I rate Dremio a nine in terms of stability.

For more quotes and insights, download the Dremio report

SR BI developer at BRQ Digital Solutions

Room For Improvement

Amazon Redshift users face challenges with performance, integration, cost, and features, preferring improved solutions like Snowflake's offerings.

Dremio struggles with Delta connector support, performance issues, SQL limitations, high costs, and fewer connectors than competitors.

They should bring the entire ETL data management process into Amazon Redshift.

Data Analytics, Ai & Automation Lead at a venture capital & private equity firm with 10,001+ employees

Integration with AI could be a good improvement.

Pavan Kum

Analyst at Cepstrum(EEE Students Society), IIT Guwahati

Integration with AI features could elevate its capabilities and popularity.

For more quotes and insights, download the Amazon Redshift report

Data engineer at a tech vendor with 10,001+ employees

Starburst comes with around 50 connectors now.

KamleshPant

Senior Software Architect at USEReady

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.

SyedIsmail

Senior Consultant - Data Analytics at a comms service provider with 201-500 employees

I see that many times the new versions of Dremio have not fixed old bugs, and in some new versions, old problems that were previously fixed come back again, so I think the upgrade part could use improvement.

For more quotes and insights, download the Dremio report

SR BI developer at BRQ Digital Solutions

Setup Cost

Amazon Redshift offers mid-to-high pricing, seen as reasonable due to its scalability and potential cost-effectiveness compared to competitors.

Dremio's pricing, though costly for scaling, is seen as valuable compared to competitors, requiring careful evaluation based on needs.

The cost of technical support is high.

RiteshPurbey

Senior Analyst at ESRI INDIA

It's a pretty good price and reasonable for the product quality.

For more quotes and insights, download the Amazon Redshift report

Data Analytics, Ai & Automation Lead at a venture capital & private equity firm with 10,001+ employees

The pricing of Amazon Redshift is expensive.

reviewer1099677

Co-Founder, Director at a tech consulting company with 51-200 employees

No quotes available

For more quotes and insights, download the Dremio report

Valuable Features

Amazon Redshift offers scalability, fast queries, AWS integration, flexibility, security, cost-effectiveness, easy setup, and compatibility for complex data management.

Dremio offers efficient data management and visualization with seamless integration, native SQL, and role-based access control features.

Amazon Redshift's performance optimization and scalability are quite helpful, providing functionalities such as scaling up and down.

For more quotes and insights, download the Amazon Redshift report

Data Analytics, Ai & Automation Lead at a venture capital & private equity firm with 10,001+ employees

Scalability is also a strong point; I can scale it however I want without any limitations.

reviewer1099677

Co-Founder, Director at a tech consulting company with 51-200 employees

The specific features of Amazon Redshift that are beneficial for handling large data sets include fast retrieval due to cloud services and scalability, which allows us to retrieve data quickly.

Pavan Kum

Analyst at Cepstrum(EEE Students Society), IIT Guwahati

Having everything under one system and an easier-to-work-with interface, along with having API integrations, adds significant value to working with Dremio.

SyedIsmail

Senior Consultant - Data Analytics at a comms service provider with 201-500 employees

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.

Joao Silveira

Data Analyst at a insurance company with 501-1,000 employees

You just get the source, connect the data, get visualization, get connected, and do whatever you want.

KamleshPant

Senior Software Architect at USEReady

For more quotes and insights, download the Dremio report

Categories and Ranking

Amazon Redshift

Ranking in Cloud Data Warehouse

6th

Average Rating

7.8

Reviews Sentiment

6.9

Number of Reviews

Ranking in other categories

Data Warehouse (6th), Database Management Systems (DBMS) (8th)

Dremio

Ranking in Cloud Data Warehouse

8th

Average Rating

8.4

Reviews Sentiment

6.6

Number of Reviews

Ranking in other categories

Data Science Platforms (10th)

Mindshare comparison

As of May 2026, in the Cloud Data Warehouse category, the mindshare of Amazon Redshift is 7.0%, down from 7.4% compared to the previous year. The mindshare of Dremio is 5.1%, down from 10.9% compared to the previous year. It is calculated based on PeerSpot user engagement data.

Cloud Data Warehouse Mindshare Distribution
Product	Mindshare (%)
Amazon Redshift	7.0%
Dremio	5.1%
Other	87.9%

Cloud Data Warehouse

Featured Reviews

Optimized restaurant analytics has driven faster insights and streamlined daily reporting

Data engineer at a tech vendor with 10,001+ employees

Amazon Redshift offers massive parallel processing capability, allowing it to handle millions of records, along with integration with other AWS features such as S3 and QuickSight. The column-level storage supports high performance and easy data retrieval compared to other tools. The integration with S3 has helped my team immensely since S3 is our starting source, and the direct integration with Amazon Redshift simplifies the transformation and loading process. Columnar storage has benefited our performance significantly, allowing us to extract specific rows from tables with years of data much faster than other tools with row-level storage. Amazon Redshift has positively impacted our organization by significantly improving query performance and speed. Features such as easy integration with S3 allow us to process millions of records efficiently, ultimately saving us nearly one hour per day for our project.

Read full review

Has simplified complex data integration workflows and supported consistent reporting across multiple sources

SR BI developer at BRQ Digital Solutions

We also have a close relationship with the team that does the Dremio maintenance for the database, like upgrading the versions and they know about some specific problems we had in the past, such as a memory leak. We had a memory leak on some versions, which sometimes stopped the service. Since we are using Dremio installed like a server, not a SaaS solution, many times we need to stop and restart the service to clear all the cache and all that, and this is the thing I should add. I see that many times the new versions of Dremio have not fixed old bugs, and in some new versions, old problems that were previously fixed come back again, so I think the upgrade part could use improvement. I remember using some features in the past, like pivot tables, which proved to be really difficult, but I know this is a fault also for other vendors. Pivoting, transposing, and unpivoting are often not so good. CTEs also many times prove to be not so good, so I think these two main items could be improved significantly if they standardize them.

Read full review

See which vendors are best for you

Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.

See recommendations

893,221 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Financial Services Firm

20%

Manufacturing Company

Computer Software Company

Construction Company

Financial Services Firm

26%

Computer Software Company

Healthcare Company

Comms Service Provider

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

By reviewers
Company Size	Count
Small Business	27
Midsize Enterprise	21
Large Enterprise	29

By reviewers
Company Size	Count
Small Business	1
Midsize Enterprise	5
Large Enterprise	5

Questions from the Community

How does Amazon Redshift compare with Microsoft Azure Synapse Analytics?

Amazon Redshift is very fast, has a very good response time, and is very user-friendly. The initial setup is very straightforward. This solution can merge and integrate well with many different dat...

What is your experience regarding pricing and costs for Amazon Redshift?

My experience with pricing and setup cost is satisfactory, as we have been loyal clients of Amazon since the beginning of our organization. However, I am not aware of the exact costs associated wit...

What needs improvement with Amazon Redshift?

Amazon Redshift could improve by enhancing its UI to be more user-friendly for non-technical users and by offering better cost management, as similar tools tend to be less expensive. Additionally, ...

What is your experience regarding pricing and costs for Dremio?

I don't have information about pricing, setup cost, and licensing for Dremio, so I am not entitled to discuss it.

What needs improvement with Dremio?

I wouldn't say there is anything Dremio can be improved on. If I could change something, I would say many developers and programmers, when they are starting to work in this specific field or area, ...

What is your primary use case for Dremio?

I have been using Dremio for a year and a half. My main use case for Dremio is that I am able to access multiple databases and I can easily and quickly connect Dremio with my dashboards. In my rece...

Snowflake vs Amazon Redshift

Comparisons

Compared 14% of the time

Teradata vs Amazon Redshift

Compared 8% of the time

Microsoft Azure Synapse Analytics vs Amazon Redshift

Compared 6% of the time

Amazon EMR vs Amazon Redshift

Compared 5% of the time

AWS Lake Formation vs Amazon Redshift

Compared 5% of the time

More Amazon Redshift Competitors

Databricks vs Dremio

Compared 19% of the time

Snowflake vs Dremio

Compared 11% of the time

BigQuery vs Dremio

Compared 4% of the time

Amazon SageMaker vs Dremio

Compared 4% of the time

Starburst Galaxy vs Dremio

Compared 3% of the time

More Dremio Competitors

Product Reports

Download Amazon Redshift product report

Amazon Redshift

May 2026

Download Dremio product report

May 2026

Also Known As

No data available

Dremio AWS - BYOL

Overview

Amazon Redshift is a dynamic data warehousing and analytics platform offering scalability and seamless AWS integration for high-performance query processing and diverse data management.

Amazon Redshift provides robust data integration capabilities with AWS services like S3 and QuickSight, enabling efficient data warehousing and analytics. It is known for fast query performance due to its columnar storage and can handle diverse file formats. With a user-friendly SQL interface, Redshift supports data compression and offers a strong cost-performance ratio. Its secure VPC configurations and compatibility with data science tools enhance its functionality, although there is room for improving snapshot restoration, dynamic scaling, and processing large datasets.

What are the key features of Amazon Redshift?

Scalability: Allows growth with business needs, accommodating increasing data volumes.
Massive Parallel Processing: Speeds up query performance through parallel data processing.
Seamless AWS Integration: Connects smoothly with services like S3 and QuickSight for enhanced functionality.
Columnar Storage: Enhances query performance by storing data in columns.
User-friendly SQL Interface: Simplifies data query and manipulation.
Data Compression: Efficiently compresses data to reduce storage costs.

What benefits should users look for in reviews?

Cost-Performance Ratio: Offers competitive pricing with high processing efficiency.
Fast Query Performance: Delivers quick data retrieval and processing speeds.
Security Features: Ensures data security through VPC configurations.
Integration Flexibility: Easily integrates with data science tools and BI platforms.

In industries, Amazon Redshift is essential for managing extensive datasets for business intelligence, operational insights, and reporting. It supports data integration from ERPs and S3, handles SQL queries for comprehensive analysis, and facilitates data storage and transformation. Companies use it for predictive modeling and connect with BI tools like Tableau and Power BI to derive actionable insights.

Amazon Web Services (AWS)

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?

Native Error Interfaces: Simplifies error detection and troubleshooting
Integration with Apache Airflow: Enhances workflow automation capabilities
Scalability: Effortlessly handles growing data demands
Role-Based Access Management: Provides secure data access control
Data Reflection: Optimizes query performance automatically
Query Federation: Supports queries across multiple endpoints seamlessly
Data Cataloging and Virtualization: Offers streamlined data organization

What benefits and ROI should users look for?

Reduced Data Storage Costs: Efficiently manages data to minimize storage expenses
Improved Query Performance: Enhances processing speed for large datasets
Flexibility in Integration: Easily connects with storage solutions like Oracle and MySQL
Enhanced Data Management: Supports comprehensive data analysis workflows

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.

Sample Customers

Liberty Mutual Insurance, 4Cite Marketing, BrandVerity, DNA Plc, Sirocco Systems, Gainsight, Blue 449

UBS, TransUnion, Quantium, Daimler, OVH