Try our new research platform with insights from 80,000+ expert users

Amazon Redshift vs Databricks comparison

 

Comparison Buyer's Guide

Executive Summary

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.2
Amazon Redshift offers mixed returns; beneficial for high data volumes, but concerns arise over rising costs and limited data effectiveness.
Sentiment score
6.6
Organizations experience mixed returns from Databricks, with benefits from cost savings and efficiency, but challenges in initial migration.
When it comes to big data processing, I prefer Databricks over other solutions.
For a lot of different tasks, including machine learning, it is a nice solution.
 

Customer Service

Sentiment score
6.8
Amazon Redshift's support is responsive but costly, with quick responses for routine issues, though advanced support can be inconsistent.
Sentiment score
7.2
Databricks customer service is generally effective with prompt responses, though some report issues mainly with third-party support channels.
It's costly when you enable support.
Whenever we reach out, they respond promptly.
 

Scalability Issues

Sentiment score
7.3
Amazon Redshift is generally praised for scalability, though experience varies with larger clusters and specific configurations.
Sentiment score
7.4
Databricks is praised for efficient scalability and cloud compatibility, allowing easy resource adjustment across diverse projects and industries.
The scalability part needs improvement as the sizing requires trial and error.
The patches have sometimes caused issues leading to our jobs being paused for about six hours.
 

Stability Issues

Sentiment score
7.4
Amazon Redshift is praised for stability, high availability, and performance, despite occasional challenges with complex queries and environment changes.
Sentiment score
7.7
Databricks is stable and efficient for large data, with minor issues during updates and occasional connectivity challenges.
Amazon Redshift is a stable product, and I would rate it nine or ten out of ten for stability.
They release patches that sometimes break our code.
Cluster failure is one of the biggest weaknesses I notice in our Databricks.
 

Room For Improvement

Amazon Redshift faces challenges in performance, integration, cost, and compatibility, needing improvements in speed, security, and serverless options.
Databricks users desire improved UI, enhanced data visualization, better integration, clearer error messages, robust support, and comprehensive documentation.
They should bring the entire ETL data management process into Amazon Redshift.
It would be beneficial to have utilities where code snippets are readily available.
Adjusting features like worker nodes and node utilization during cluster creation could mitigate these failures.
We prefer using a small to mid-sized cluster for many jobs to keep costs low, but this sometimes doesn't support our operations properly.
 

Setup Cost

Amazon Redshift offers competitive pricing for large enterprises, but smaller organizations might find it more costly than alternatives.
Databricks pricing depends on usage, with flexibility in licensing, and can vary in competitiveness compared to other solutions.
The cost of technical support is high.
It's a pretty good price and reasonable for the product quality.
The pricing of Amazon Redshift is expensive.
 

Valuable Features

Amazon Redshift provides scalable, efficient data processing with AWS integration, offering robust analytics, security, and user-friendly features.
Databricks provides a unified platform for data engineering, machine learning, seamless cloud integration, and robust data management capabilities.
Amazon Redshift's performance optimization and scalability are quite helpful, providing functionalities such as scaling up and down.
Scalability is also a strong point; I can scale it however I want without any limitations.
Security configurations are implemented across all processes, such as AWS Config and GuardDuty.
Databricks' capability to process data in parallel enhances data processing speed.
The notebooks and the ability to share them with collaborators are valuable, as multiple developers can use a single cluster.
 

Categories and Ranking

Amazon Redshift
Ranking in Cloud Data Warehouse
5th
Average Rating
7.8
Reviews Sentiment
6.9
Number of Reviews
70
Ranking in other categories
No ranking in other categories
Databricks
Ranking in Cloud Data Warehouse
7th
Average Rating
8.2
Reviews Sentiment
7.0
Number of Reviews
88
Ranking in other categories
Data Science Platforms (1st), Streaming Analytics (1st)
 

Mindshare comparison

As of April 2025, in the Cloud Data Warehouse category, the mindshare of Amazon Redshift is 7.2%, down from 9.2% compared to the previous year. The mindshare of Databricks is 8.4%, up from 3.2% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Cloud Data Warehouse
 

Featured Reviews

Ved Prakash Yadav - PeerSpot reviewer
Works as a data warehouse system and collects data from different sources
In terms of improvement, I believe Amazon Redshift could work on reducing its costs, as they tend to increase significantly. Additionally, there are occasional issues with nodes going down, which can be problematic. We often encounter issues like someone dropping a column or changing the order of columns, which can cause synchronization problems when pushing data through our pipeline. It's a minor issue, but it can be annoying.
ShubhamSharma7 - PeerSpot reviewer
Capability to integrate diverse coding languages in a single notebook greatly enhances workflow
Databricks offers various courses that I can use, whether it's PySpark, Scala, or R. I can leverage all these courses in a single notebook, which is beneficial for clients as they can access various tools in one place whenever needed. This is quite significant. I usually work with PySpark based on client requirements. After coding, I feed the Databricks notebooks into the ADF pipeline for updates. Databricks' capability to process data in parallel enhances data processing speed. Furthermore, I can connect our Databricks notebook directly with Power BI and other visualization tools like Qlik. Once we develop code, it allows us to transform raw data into visualizations for clients using analysis diagrams, which is very helpful.
report
Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
848,207 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Educational Organization
64%
Financial Services Firm
6%
Computer Software Company
5%
Manufacturing Company
3%
Financial Services Firm
17%
Computer Software Company
10%
Manufacturing Company
9%
Healthcare Company
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

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 do you like most about Amazon Redshift?
The tool's most valuable feature is its parallel processing capability. It can handle massive amounts of data, even when pushing hundreds of terabytes, and its scaling capabilities are good.
Which do you prefer - Databricks or Azure Machine Learning Studio?
Databricks gives you the option of working with several different languages, such as SQL, R, Scala, Apache Spark, or Python. It offers many different cluster choices and excellent integration with ...
How would you compare Databricks vs Amazon SageMaker?
We researched AWS SageMaker, but in the end, we chose Databricks. Databricks is a Unified Analytics Platform designed to accelerate innovation projects. It is based on Spark so it is very fast. It...
Which would you choose - Databricks or Azure Stream Analytics?
Databricks is an easy-to-set-up and versatile tool for data management, analysis, and business analytics. For analytics teams that have to interpret data to further the business goals of their orga...
 

Comparisons

 

Also Known As

No data available
Databricks Unified Analytics, Databricks Unified Analytics Platform, Redash
 

Overview

 

Sample Customers

Liberty Mutual Insurance, 4Cite Marketing, BrandVerity, DNA Plc, Sirocco Systems, Gainsight, Blue 449
Elsevier, MyFitnessPal, Sharethrough, Automatic Labs, Celtra, Radius Intelligence, Yesware
Find out what your peers are saying about Amazon Redshift vs. Databricks and other solutions. Updated: March 2025.
848,207 professionals have used our research since 2012.