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.
"The most valuable feature of Databricks is the notebook, data factory, and ease of use."
"Specifically for data science and data analytics purposes, it can handle large amounts of data in less time. I can compare it with Teradata. If a job takes five hours with Teradata databases, Databricks can complete it in around three to three and a half hours."
"The solution is very easy to use."
"The most valuable feature of Databricks is the integration with Microsoft Azure."
"We like that this solution can handle a wide variety and velocity of data engineering, either in batch mode or real-time."
"The load distribution capabilities are good, and you can perform data processing tasks very quickly."
"Databricks makes it really easy to use a number of technologies to do data analysis. In terms of languages, we can use Scala, Python, and SQL. Databricks enables you to run very large queries, at a massive scale, within really good timeframes."
"Databricks covers end-to-end data analytics workflow in one platform, this is the best feature of the solution."
"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."
"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."
"Dremio allows querying the files I have on my block storage or object storage."
"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."
"The product should incorporate more learning aspects. It needs to have a free trial version that the team can practice."
"I would like to see the integration between Databricks and MLflow improved. It is quite hard to train multiple models in parallel in the distributed fashions. You hit rate limits on the clients very fast."
"The integration features could be more interesting, more involved."
"It would be very helpful if Databricks could integrate with platforms in addition to Azure."
"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."
"The data visualization for this solution could be improved. They have started to roll out a data visualization tool inside Databricks but it is in the early stages. It's not comparable to a solution like Power BI, Luca, or Tableau."
"Overall it's a good product, however, it doesn't do well against any individual best-of-breed products."
"The ability to customize our own pipelines would enhance the product, similar to what's possible using ML files in Microsoft Azure DevOps."
"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."
"I cannot use the recursive common table expression (CTE) in Dremio because the support page says it's currently unsupported."
"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."
"It shows errors sometimes."
"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."
Databricks is ranked 1st in Data Science Platforms with 77 reviews while Dremio is ranked 8th 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 "Quick database capabilities but sometimes shows minor errors". Databricks is most compared with Amazon SageMaker, Informatica PowerCenter, Microsoft Azure Machine Learning Studio, Dataiku Data Science Studio and Tableau, whereas Dremio is most compared with Snowflake, Starburst Enterprise, Amazon Redshift, Microsoft Azure Synapse Analytics and BigQuery. 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.