Dremio Reviews & Product Details

Dremio Overview

What is Dremio?

Maximize the power of your data with Dremio—the data lake engine. Dremio operationalizes your cloud data lake storage and speeds your analytics processes with a high-performance and high-efficiency query engine while also democratizing data access for data scientists and analysts via a governed self-service layer. The result is fast, easy data analytics for data consumers at the lowest cost per query for IT and data lake owners.

Dremio Details
Website
Languages Supported
English
Product Description

Dremio is a data analysis software. It is self-service data platform provided that users discover, accelerate and share data at any time.

How do you position yourself against your competitors?

Dremio is shattering a 30-year-old paradigm that holds virtually every company back—the belief that, in order to query and analyze data, data teams need to extract and load it into a costly, proprietary data warehouse. We’re removing those limitations, accelerating time to insight and putting control in the hands of the user.

Dremio leads in both cost-savings and performance when looking at data lake query engines such as PrestoDB, PrestoSQL, Starburst Presto and AWS Athena by delivering 3,000x faster ad hoc queries using 1/3000th of the EC2 compute infrastructure.


Seller Details
Seller
Dremio
Company Website
Year Founded
2015
HQ Location
Santa Clara, California
LinkedIn® Page
www.linkedin.com
167 employees on LinkedIn®
Show More

Dremio Videos

Dremio Screenshots

Answer a few questions to help the Dremio community
Have you used Dremio before?
Yes

Dremio Reviews

Write a Review
Filter reviews
LinkedIn®
Connections
Popular Mentions
Showing 21 Dremio reviews
Popular Mentions
Showing 21 reviews
Filter Reviews
Filter Reviews
Sort by
Ratings
Company Size
User Role
For Category
All Industries
Region
Already have Dremio?
Write a Review
Mid-Market(51-1000 emp.)
Validated Reviewer
Verified Current User
Review source: Invitation from the seller
What do you like best?

-Convenient web interface for running SQL queries on our data

-Supports a broad range of data source

-Processing for queries is extremely fast when accelerated (rarely over 1 second)

-Python API is fairly easy to use

-Prompt and knowledgeable support team that are always willing to walk us through problems over video call Review collected by and hosted on G2.com.

What do you dislike?

It's hard to say, because most/all of the problems that we've had with Dremio are likely because we're several versions behind due to compatibility problems with some of our legacy infrastructure. eg. missing features that exist in newer versions, or instability problems with reflections that are probably remedied in newer versions. That's on us, though. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

For queries over the Python API that return a significant amount of data, make sure you're using ODBC or pyarrow flight rather than the more basic REST API, as it's likely to be a lot faster. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

I'm not sure how specific I'm allowed to be so I'm going to be vague here, but we use Dremio as a data platform for an internal analytics tool. It's a convenient way to access a central data source from multiple deployed versions of the tool (for development or demo purposes), so it's been very beneficial for development purposes over our more rudimentary old model. Review collected by and hosted on G2.com.

Show More
Show Less
Senior Berater
Mid-Market(51-1000 emp.)
Validated Reviewer
Verified Current User
Review source: Invitation from the seller
Business partner of the seller or seller's competitor, not included in G2 scores.
What do you like best?

Dremio managed to provide a wide range of existing analysis tools with universal, fast and direct access to the data in a data lake. The time required to provide data and the IT footprint is reduced to a minimum. Intelligent options for caching query results and entire aggregates in memory for specific analysis scenarios makes working with these two tools a pleasure. Review collected by and hosted on G2.com.

What do you dislike?

Currently there is no managed service on the Microsoft Azure platform, which makes deployment difficult. However, Dremio is working hard on this issue. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

Have a look at Dremio University. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

The goal with an analysis tool such as Power BI is to discover new insights and to visually present these insights so that other employees can understand them and make better decisions.

Nobody wants to deal with the acquisition or transformation of data. If you have a large amount of data, it is not practical to load this data into Power BI. Dremio enables us to perform analyses directly on the data in the Date Lake without the need for copying.

This turns a Data Lake into a database that can be queried by SQL. Review collected by and hosted on G2.com.

Show More
Show Less
Enterprise(> 1000 emp.)
Validated Reviewer
Verified Current User
Review source: Invitation from the seller
What do you like best?

Dremio is a powerful solution to connect your applications and BI tools to your data lake. They are very innovative and fast-paced to deliver new features and enhancements. The professional support team is very helpful and tries to understand the customer needs to deliver the best value. The variety of connectors available for the different data sources is really amazing as well the possibility to easily create custom connectors. The fact that the company contributes back to the community developing or open-sourcing tools is really nice. Review collected by and hosted on G2.com.

What do you dislike?

I believe Dremio's weakness is related to CI/CD because there is a couple of libraries, articles and even an open-sourced tool (which is great) to achieve it but it's still very hard and complex to have full automation. As I mentioned before, Dremio is very innovative and fast-paced, so, I believe they will address soon. One missing feature is the native support for Databricks Delta format but as far as I know it's on the roadmap and there is a workaround to be able to work with Delta. Another missing feature is the multi-master solution, it would be very helpful mainly when doing maintenances on the coordinator. Last but not least, it would be good to have the capability to use groups even when not integrated with an AD, LDAP, etc. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

Dremio is a very powerful and fast-growing tool and the support team is very helpful. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

I'm delivering data from our data lake on top of Azure Data Lake Gen2 for both microservices through Rest API and BI tools such as Power BI. We are also using Dremio to accelerate and empower our teams to understand and take insights from data to meet business needs. Review collected by and hosted on G2.com.

Show More
Show Less
Managing Delivery Architect, Insights&Data
Enterprise(> 1000 emp.)
Validated Reviewer
Verified Current User
Review source: Invitation from the seller
Business partner of the seller or seller's competitor, not included in G2 scores.
What do you like best?

Dremio helps us a lot to manage a high workloads from our reportnig systems and achieve a fast response time for more then 500 management dashboards. Many of our end-users like work with Dremio to avoid additional Data Engineering skills in team. For some of them it was surprisely fast after changing the Reporting from "Import" to "live" connection to move data processing directly to Dremio. But the most demanded feature was Reflections which gave sometimes lightning-fast (less then 1 second) response time without any re-engineering of business logic or reducing the data volumes.

In case of any issues and challenges Dremio was very cooperative on Germany and global level to solve it. Review collected by and hosted on G2.com.

What do you dislike?

As Dremio do not implemented Elastic Engine on Azure we need to maintain Kubernetes cluster to reach out needed ad-hoc scale-out requirements. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

Based on my exprerience Dremio fits for usecases when you:

..have Multi-Cloud stategy and want to avoid "lock-in" effect into one of cloud-vendor solution

..have onPremise Hadoop cluster or ODS store which performance is not enough

..have end users which wants to work directly with data, but have only SQL knowlegde

..want to offload data processing to Dremio from you BI-tools like Tableau or Power BI

..have usecases where time-to-market has a huge value (like a ad-hoc data exploration in Data Science) Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

We have a different use cases on the same shared Dremio instance - "classical" Management Reporting, Self Service BI, Data exploration, AI Use Cases and Business Process Automation.

So our worloads ware not equal in time and not always predictable from "big-bang" requests and high-volume scans. But Dremio managed it in smooth way. Review collected by and hosted on G2.com.

Show More
Show Less
Data Engineer
Mid-Market(51-1000 emp.)
Validated Reviewer
Review source: Invitation from the seller
What do you like best?

* Integrates nicely with AWS. supports s3 buckets and aws hosted databases as data sources, as well as being able to use aws glue as a metastore.

* It's fast. Dremio is able to perform complex operations at scale very quickly. Many of our workloads that took tens of hours on our previous data analytics solution, now finish in under a minuet.

* Able to use a wide variety of data sources together. We able to seamlessly combine data from PostgreSQL and parquet files stored on S3 in a single query.

* Easy to connect to from external tools. Using their JDBC, a variety ODBC connectors and REST API we've been able to easily connect to, and use Dremio with a number of external tools on hosted linux or local windows. Jupyter, datagrip, excel, tableau.

* Great support and PS team. Having worked with the support team on issues ranging from inconsequential to major blockers, they have always been very responsive and fast acting. Review collected by and hosted on G2.com.

What do you dislike?

* Isn't currently transactional for data in an object store (s3). At least for an s3 data source you can't define a table then insert data into it. Any data written must be done via a Create table as Select style statement.

* Error clarity. initial errors displayed to users can be quite opaque requiring one to click through to a deeper menu to find the root cause. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

One tool that can query and combine all our data fast despite being stored in different locations with different formats. Review collected by and hosted on G2.com.

Show More
Show Less
AI
Mid-Market(51-1000 emp.)
Validated Reviewer
Verified Current User
Review source: Invitation from the seller
Business partner of the seller or seller's competitor, not included in G2 scores.
What do you like best?

The product is great but for me its the people. Committed to our success, easy to work with, friendly and professional. From the beginning, we had positive interactions with Dremio and that didn't change after we became a customer. Dremio is a great partner for our company. Review collected by and hosted on G2.com.

What do you dislike?

Its still a relatively new platform so limited community information available. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

Run a proof of concept, get comfort with it yourself. You will not be disappointed. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

We have already proved that we can turn around Data Analytics in a far shorter time with superior performance compared to our legacy technology stack. We would spend hours moving data around via ETL and then some time spent processing cubes or slow queries. Dremio has smoltified this process a lot. As a company we like using SQL and Dremio provides a SQ L access to our data planform which is a hug plus. Review collected by and hosted on G2.com.

Show More
Show Less
EF
Mid-Market(51-1000 emp.)
Validated Reviewer
Verified Current User
Review source: Invitation from the seller
What do you like best?

Fast and user-friendly query engine on top of open standard parquet files without the hassle of data loading process to a proprietary vendor format. We used to have to load our Spark-processed data to AWS Redshift in order to get decent performance from our datasets and then we use AWS Athena to avoid the hassle of secondary data loading, but encounter issues with performance SLA with Athena when traffic increases. With Dremio, we have the best of both worlds where the get the comparable performance of Redshift for most of our queries without the hassle of data loading and the reliable performance SLA. The nice user-friendly GUI that our users can use for their SQL queries is definitely a big plus for our end-user tooling and onboarding.

Aside from these, their AWS Edition has the great Elastic Engine feature that helps you save cost by turning off the engine when not in use and automatically turn it on when a query comes in. This has helped us keep our costs under control. Review collected by and hosted on G2.com.

What do you dislike?

The support for larger datasets with a large number of splits is an issue currently, but the move to use Apache Iceberg is in the works to overcome this limitation. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

If you dislike proprietary vendor format and the hassle of the data loading process, try this out. Try their community AWS Edition which has most of the features that you would need. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Data virtualization and democratization. As most of our users come from SQL background, Dremio is the perfect solution for these users to something that they are already familiar with. The web GUI has streamlined our data quality analysts' job as they can simply perform their initial data exploration from the GUI. Review collected by and hosted on G2.com.

Show More
Show Less
Enterprise(> 1000 emp.)
Validated Reviewer
Verified Current User
Review source: Invitation from the seller
What do you like best?

The ease of use. We all know SQL and that is very flexible. No coding promises great things, but never deliver and complex development is taking a huge amount of time. Everybody understanding SQL should not go to No-Coding for speed, flexibility and (future) migration. Review collected by and hosted on G2.com.

What do you dislike?

The documentation on available functions is lacking. Dremio does not have a built-in Intellisense nor autosave. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Virtual data warehousing directly on Microsoft CDM. Review collected by and hosted on G2.com.

Show More
Show Less
AA
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: Invitation from the seller
What do you like best?

The confluence of open source technologies to solve one of the most challenging problems of todays Big Data environments. I applaud Dremio and its team in fusing together technologies like Apache Arrow, Vectorized engine, Iceberg etc to bring a unique approach to accelerating the data lake.

The approach to self service through semantic engineering of data has created a new dimension to data analysis and data curation. Review collected by and hosted on G2.com.

What do you dislike?

Dremio's lack of support for database views and external decryption libraries, has created a perception that sometimes overshadows all the advantages it brings. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Democratizing data by getting data into the hands of the users through self service. Reaping the benefits of Arrow for speed. Leveraging Dremio's support for Iceberg to cater to consumption scenarios that are unpredictable. Leveraging Iceberg's hidden partitioning through Dremio is a key in this area. Review collected by and hosted on G2.com.

Show More
Show Less
IC
Enterprise(> 1000 emp.)
Validated Reviewer
Verified Current User
Review source: Invitation from the seller
What do you like best?

Simplification – Single point of data access.

Data Blending – Merge diverse data pools easily

Protection – Enable security and authorization.

Acceleration – Performant reporting and analysis Review collected by and hosted on G2.com.

What do you dislike?

Different roadmap AWS and Azure and not all capabilities you have in AWS are in Azure Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

We organized the Lake like a virtual LAB or APP. In a APP we provide for all our user the correct folder structure and all the resources they need to analyze data.

Dremio use the Data lake as a data source . From outside, Dremio looks and behaves like a relational Database Review collected by and hosted on G2.com.

Show More
Show Less
EF
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: Invitation from the seller
What do you like best?

Dremio help us to transition from legacy to target state data lake architecture. it offers connectivity to both legacy data sources and modernised cloud native data lake on object storage. This allows us to produce insights across our whole data landscape since day 1 and plan out transition from legacy over time. Review collected by and hosted on G2.com.

What do you dislike?

Nothing major but it would be great if Dremio can offer connectors to more legacy data sources Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

we are looking for a modernised data management approach instead of traditional ETL approach.

The user friendly UI allowed our business users to create semantic layers on top of data lake without IT involvements, it also help to drive adoption in business as this approach offer significant time to market advantage, compare to the legacy ETL approach. Review collected by and hosted on G2.com.

Show More
Show Less
Mid-Market(51-1000 emp.)
Validated Reviewer
Verified Current User
Review source: Invitation from the seller
What do you like best?

Enabling interactive speed queries on Hadoop Review collected by and hosted on G2.com.

What do you dislike?

Can be misused as a mainstream ELT tool. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Making Hadoop as the mainstream data platform for all consumers. This tool has really flattened the Change management curve for the BI community in adopting the Data Lake on Hadoop Review collected by and hosted on G2.com.

Show More
Show Less
EF
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: Organic
What do you like best?

Upon selecting Dremio as a targeted consumption solution for our enterprise data footprint, Dremio immediately came along side our organization with their architects, designers, and client partners to understand the pending impediments. Through an arduous internal process, Dremio was able to quickly modify their platform to meet our security and compliance needs for a rapid deployment ultimately meeting out timelines. Review collected by and hosted on G2.com.

What do you dislike?

So far so good, they have been nothing but great partners. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

In our large scale data environment we are looking to leverage strategic tools like Dremio in order to limit the transformation and ingestion activities that currently take place within our enterprise lakes. Dremio will ultimately reduce our ETL developments allowing us to deliver insights and results to our business partners significantly faster. Review collected by and hosted on G2.com.

Show More
Show Less
AF
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: Invitation from the seller
What do you like best?

Amazing performance with Apache Arrow at its core with new enhancements actively developed with the open source community such as Gandiva for optimized execution and Flight for optimized data transfer. Project Nessie is also being worked on in the open source community to bring git-like version history to datasets. Review collected by and hosted on G2.com.

What do you dislike?

There can be better support for large datasets in the TB/PB range in terms of dataset management, with something like Iceberg support, which is in the works. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Building an open file-based data warehouse that can scale to speed up existing RDBMS-based workloads and allow new and more advanced use cases to be developed on top of data from various sources. Review collected by and hosted on G2.com.

Show More
Show Less
IF
Small-Business(50 or fewer emp.)
Validated Reviewer
Review source: Invitation from the seller
What do you like best?

What I like best about Dremio is the open source foundation and commitments to the open source community. This is most notable in the various database connector where we have the freedom to create our own or modify as needed. Review collected by and hosted on G2.com.

What do you dislike?

The limitations in connection to legacy DBs and there are limitation in maintaining sessions and passing things like "Alter" commands to source databases. This can increase development and adoption timelines. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Dremio is positioned to solve for virtualization and federation to legacy databases as well as their core product of enabling SQL interfaces on data lakes. Review collected by and hosted on G2.com.

Show More
Show Less
Mid-Market(51-1000 emp.)
Validated Reviewer
Review source: Invitation from the seller
What do you like best?

Easy to use, SQL based, No data movement, optimizing and integrate queries and/or the use of reflections for a high analyzing performance Review collected by and hosted on G2.com.

What do you dislike?

At this moment no actual issues, maybe a missing data dictionary Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

No data movement, self service analytics Review collected by and hosted on G2.com.

Show More
Show Less
UA
Enterprise(> 1000 emp.)
Validated Reviewer
Verified Current User
Review source: Invitation from G2
What do you like best?

Ability and ease to view data, especially parquet files and their data types. Review collected by and hosted on G2.com.

What do you dislike?

There is not much to dislike, the UI is great too and documentation is thorough. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Ability to consolidate multiple data sources of big data. Ability to aggregate across DBs and make data available from a single endpoint. Review collected by and hosted on G2.com.

Show More
Show Less
AF
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: Invitation from the seller
What do you like best?

Dremio has a ton of support out of the box for a wide array of data sources. The professional services support is also world class. Review collected by and hosted on G2.com.

What do you dislike?

The scope of the amount of products it supports can lead to some slow problem resolutions for lesser used data source connections and edge case problems Review collected by and hosted on G2.com.

Recommendations to others considering the product:

Their docs are extremely thorough. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

A unified query layer to allow data exploration among disparate data sources Review collected by and hosted on G2.com.

Show More
Show Less
AL
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: Invitation from the seller
What do you like best?

Dremio is a very simple tool to deploy and with OSS technology. We benched many solutions in order to find an performing tool that can accelerate Analytics & ML on-premise Review collected by and hosted on G2.com.

What do you dislike?

Need better integration with Analytics tools like spark (ex: native connectors...) Review collected by and hosted on G2.com.

Recommendations to others considering the product:

Give a try to Dremio ! you will be surprised. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

- Accelerate Analytics

- Avoid duplicated datasources shared between Analytics & ML

- Self-service DataHub for business Review collected by and hosted on G2.com.

Show More
Show Less
EI
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: Invitation from the seller
What do you like best?

able to connect data from multiple sources via Native SQL Review collected by and hosted on G2.com.

What do you dislike?

Sharding work on individual executors can be improvise to keep it simple Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

- Central Data virtualization

- Democratizing Data

- Technical edge Review collected by and hosted on G2.com.

Show More
Show Less
AF
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: Invitation from the seller
What do you like best?

Setup and query execution also awse features, reflections Review collected by and hosted on G2.com.

What do you dislike?

Sometimes machines crashes due to aws upgrades Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Query execution is too fast around 7 times faster than athena Review collected by and hosted on G2.com.

Show More
Show Less