We compared Databricks and Dremio based on our user's reviews in several parameters.
Databricks excels in seamless integration, advanced analytics, and collaborative capabilities, with positive feedback on customer service and pricing. In contrast, Dremio is praised for query performance, data virtualization, and scalability, with excellent customer service and cost-effective pricing. Areas for improvement in Databricks include data visualization and pricing flexibility, while Dremio users note issues with performance on complex queries, documentation, and support response times.
Features: Databricks excels in seamless integration, collaborative capabilities, and advanced analytics. In contrast, Dremio stands out for its impressive query performance, data virtualization, user-friendly interface, strong security features, and scalability for large datasets.
Pricing and ROI: Databricks and Dremio have received positive user feedback regarding pricing, setup cost, and licensing. Users found both products to have reasonable and competitive pricing. The setup cost for Databricks was reported to be straightforward, while Dremio's setup process was easy and without significant costs. Both products offer flexible licensing options to meet different user needs. Overall, users had a positive experience with pricing, setup cost, and licensing of both Databricks and Dremio., Users have reported positive outcomes and returns on investment when utilizing both Databricks and Dremio. However, Databricks is praised for its significant impact on increasing efficiency, productivity, and data analysis capabilities, while Dremio is favored for providing favorable returns on investment.
Room for Improvement: Databricks could improve its data visualization capabilities, monitoring and debugging tools, integration with external sources, documentation for beginners, and pricing flexibility. Dremio needs to enhance its user interface, performance with complex queries, documentation, embedding into other applications, and support availability.
Deployment and customer support: In terms of the duration required to establish a new tech solution, user reviews for Databricks and Dremio differ. Databricks reviews mention varying durations for deployment and setup, while Dremio reviews indicate different timeframes for these processes, emphasizing the importance of context., Databricks' customer service is praised for its efficiency, helpfulness, and promptness. The support team is proactive and maintains excellent communication. Dremio's customer service is highly praised for its promptness, efficiency, and resourcefulness. Users appreciate their top-notch and reliable support.
The summary above is based on 53 interviews we conducted recently with Databricks and Dremio users. To access the review's full transcripts, download our report.
"Databricks covers end-to-end data analytics workflow in one platform, this is the best feature of the solution."
"Databricks is based on a Spark cluster and it is fast. Performance-wise, it is great."
"Imageflow is a visual tool that helps make it easier for business people to understand complex workflows."
"The ease of use and its accessibility are valuable."
"Databricks provides a consistent interface for data engineers to work with data in a consistent language on a single integrated platform for ingesting, processing, and serving data to the end user."
"I like the ability to use workspaces with other colleagues because you can work together even without seeing the other team's job."
"Databricks allows me to automate the creation of a cluster, optimized for machine learning and construct AI machine learning models for the client."
"The initial setup phase of Databricks was good."
"Everyone uses Dremio in my company; some use it only for the analytics function."
"We primarily use Dremio to create a data framework and a data queue."
"Dremio gives you the ability to create services which do not require additional resources and sterilization."
"Dremio enables you to manage changes more effectively than any other data warehouse platform. There are two things that come into play. One is data lineage. If you are looking at data in Dremio, you may want to know the source and what happened to it along the way or how it may have been transformed in the data pipeline to get to the point where you're consuming it."
"Dremio allows querying the files I have on my block storage or object storage."
"The most valuable feature of Dremio is it can sit on top of any other data storage, such as Amazon S3, Azure Data Factory, SGFS, or Hive. The memory competition is good. If you are running any kind of materialized view, you'd be running in memory."
"The product could be improved by offering an expansion of their visualization capabilities, which currently assists in development in their notebook environment."
"It would be great if Databricks could integrate all the cloud platforms."
"I would like to see more documentation in terms of how an end-user could use it, and users like me can easily try it and implement use cases."
"There are no direct connectors — they are very limited."
"Databricks doesn't offer the use of Python scripts by itself and is not connected to GitHub repositories or anything similar. This is something that is missing. if they could integrate with Git tools it would be an advantage."
"It would be nice to have more guidance on integrations with ETLs and other data quality tools."
"I have had some issues with some of the Spark clusters running on Databricks, where the Spark runtime and clusters go up and down, which is an area for improvement."
"Instead of relying on a massive instance, the solution should offer micro partition levels. They're working on it, however, they need to implement it to help the solution run more effectively."
"They have an automated tool for building SQL queries, so you don't need to know SQL. That interface works, but it could be more efficient in terms of the SQL generated from those things. It's going through some growing pains. There is so much value in tools like these for people with no SQL experience. Over time, Dermio will make these capabilities more accessible to users who aren't database people."
"Dremio takes a long time to execute large queries or the executing of correlated queries or nested queries. Additionally, the solution could improve if we could read data from the streaming pipelines or if it allowed us to create the ETL pipeline directly on top of it, similar to Snowflake."
"Dremio doesn't support the Delta connector. Dremio writes the IT support for Delta, but the support isn't great. There is definitely room for improvement."
"We've faced a challenge with integrating Dremio and Databricks, specifically regarding authentication. It is not shaking hands very easily."
"It shows errors sometimes."
"I cannot use the recursive common table expression (CTE) in Dremio because the support page says it's currently unsupported."
Databricks is ranked 1st in Data Science Platforms with 78 reviews while Dremio is ranked 9th in Data Science Platforms with 6 reviews. Databricks is rated 8.2, while Dremio is rated 8.6. The top reviewer of Databricks writes "A nice interface with good features for turning off clusters to save on computing". On the other hand, the top reviewer of Dremio writes "It enables you to manage changes more effectively than any other platform". Databricks is most compared with Amazon SageMaker, Informatica PowerCenter, Dataiku, Microsoft Azure Machine Learning Studio and Azure Stream Analytics, whereas Dremio is most compared with Snowflake, Starburst Enterprise, Amazon Redshift, Microsoft Azure Synapse Analytics and Microsoft Power BI. See our Databricks vs. Dremio report.
See our list of best Data Science Platforms vendors.
We monitor all Data Science Platforms 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.