Dremio Reviews & Product Details

I love the platform’s ability to connect to a wide array of data sources, including relational databases (PostgreSQL, MySQL, Oracle, MS SQL), NoSQL systems (MongoDB, Elasticsearch), and cloud or file-based storage like S3 and HDFS, without requiring complex ETL pipelines.

This approach simplifies data integration and reduces engineering overhead.

The SQL query engine is highly performant, delivering sub-second response times even on large datasets, and supports live data visualization and dynamic previews during query preparation.

Data reflections feature acts as an intelligent caching layer, optimizing query performance and enabling low-latency dashboard refreshes for BI workloads.

The platform’s virtual datasets allow for complex query logic to be encapsulated and reused, supporting data-as-code principles such as Git-like version control and experimentation.

Cloud-native architecture offers elastic compute scaling and is available as a managed service on AWS and Azure, making it suitable for both on-premises and cloud deployments. It supports role-based access control and multitenancy, which is essential for enterprise environments with strong data governance requirements. Review collected by and hosted on G2.com.

The learning curve can be significant, especially when configuring advanced features like data reflections, multitenancy, and integrating with complex enterprise authentication systems.

While the UI is functional, some administrative and monitoring functions feel less intuitive compared to other modern analytics platforms.

I have also found that fine-grained access controls and tenant isolation require careful configuration to avoid inadvertent data exposure in multi-tenant scenarios. Review collected by and hosted on G2.com.

its great experience using Dremio. I have used its sql query engine product. the implementation was very easy and good for freshers and non-tech people. it's not too expensive w.r.t to other platforms. I like the speed. it's quite fast. I like the customer support service. Review collected by and hosted on G2.com.

there is nothing which I dont like as I like it and its good to try on different platform for cloud and analytics work. Review collected by and hosted on G2.com.

Dremio has the most powerful data analytics i have ever seen which makes it get easy to analyze our data in depth and acquire very comprehensive insights. Its SQL engine has a simple and clean interface that allows us to easily navigate through. Dremio has also shown great flexibility which made it possible to adjust its setup in order to match with our specified needs. The customer support team assigned to us has been generously helpful and has impressed us by responding to our requests quickly enough. Dremio has extreme security functions that allows us to access, work on and analyze our data safely without making them vulnerable to any security breaches. Dremio allows us to analyze our data from where they live whether on cloud or any other environment with no need to first transfer them. It has been offering lightning fast performance speeds that allows us to analyze, query data and get results in an instance. Dremio reporting tools are very efficient and has been giving us an easy experience generating insightful reports for our data. Dremio compatibility with multiple data sources has enabled us to integrate and connect it with every data source we have. Review collected by and hosted on G2.com.

Dremio has impressed in all areas of our great concern and we are happy with the experience we are having. We have genuinely lacked anything negative to complain about Dremio. Review collected by and hosted on G2.com.

Dremio became an essential solution to maintain instant data collection in our company, which is why we decided to extend our use of Dremio in the first year of use, we noticed that the results on data collection had been very complete and had helped us to collect data from various sources and virtualize it, as well as export this data to analysis platforms. One of the things I liked most about Dremio were:

1.- Dremio integrates perfectly with platforms such as Power BI and Tableau, we currently use Dremio with Power BI integration and we have noticed that this integration has been relatively good, just by linking a new API we have been able to extract and synchronize data in real time so that our end employees can have a perfect data analysis.

2.- We store various data from our properties, financial data, customer data, and much more, so Dremio has been a completely perfect database service, with SQL support and Apache support, which allows me to connect to different data sources, extract data easily, and establish data virtualization, either to combine data or to transform new data.

3.- I love the way Dremio is able to have automated table creation, in these tables you can correctly organize all the data collected from different sources and then transfer this infromation to Power BI. The automated Power BI service and the AI it uses have helped us generate quick reports on the behavior of new data with respect to old data, to be able to see comparisons in real time, see data sources depending on regions, and much more.

4.- Dremio uses a very advanced data migration compared to other similar platforms, using very advanced protocols such as JDBC, which helps to migrate data in a few seconds, and helps to keep the transfer of data to the database almost instantaneous. Review collected by and hosted on G2.com.

One of the features that I din't like about Dremio is that originally this platform doesn't have a real-time analysis service and automatic report generation like Power BI and platforms like Tableau do. Even though I really liked this integration between both platforms because it helps me manage reports quickly, I think that Dremio should have its own BI function to enhance the analysis of new data within the platform and that data migration is not so necessary every moment. Another feature that I didn't like about Dremio is that the platform in general needs to be used by a person with a lot of experience in database management with Apache and SQL, otherwise, you will have complications for the administration and migration of data of all kinds and from any source. These have been the only negative things that I have noticed about Dremio, since with respect to the functions that it currently offers, all the functions have been useful in my company and have not given any kind of failure. Review collected by and hosted on G2.com.

Its just how easy it is to use. When we first onboarded, I was surprised at how fast we could connect to, like, multiple data sources. Didn't have a huge setup headache, which was awesome.The implementation wasn't that bad, especially comparing to some other BI tools we used. I mean, it wasn't 100% smooth, had a few little hiccups, but overall we got it running way easier than I expected.

It's got pretty rich feature set—the reflections and acceleration stuff is cool for performance, even if it feels a bit overwhelming at the start. Integrating it with our existing stuff, like our AWS S3 buckets and Snowflake, was pretty straightforward. No major drama there,Oh, and the SQL editor is way better than I thought it'd be..Overall, it just feels like a tool built for speed and flexibility. we use sometimes multiple times a day when I have to do ad-hoc analysis or explore big datasets Yeah, there's definitely a learning curve, no lie. But once you get past that, you realize how powerful it is. Review collected by and hosted on G2.com.

Their customer support is decent. Sometimes they take a bit to get back to you, but most of the time I've gotten a proper solution that actually fixes the problem. The performance is weird sometimes, like one day a query runs blazing fast, and then the next day the exact same query is just... slower. For no obvious reason, The UI also feels a little clunky at times, not gonna lie. Especially when you're trying to handle a really large dataset, it'll just freeze up for a second , laggy . Makes the whole experience feel less smooth than it should.And the documentation... yeah, it could definitely be better. A lot of times I've had to just google around on forums or actually reach out to support just to find some small configuration detail that should really be in the main docs. Wastes a bunch of time.

Also it's not exactly cheap. When you start to really scale it up, especially running on our own cloud infra, the bills start to add up. I feel like for smaller teams, the admin side of things can feel too complex for what you need. Just setting up user permissions and everything is a whole thing. Review collected by and hosted on G2.com.

It is super user friendly and helps to handle big ranges of data. Review collected by and hosted on G2.com.

Fairly speaking there is not a lot to say about that. Users can get what they expect from optimal data cloud. Review collected by and hosted on G2.com.

Dremio is easy to configure and maintain, requiring little effort to implement from small to large clusters. It is well-documented, easy to extend, and integrates smoothly with other applications. It efficiently utilizes resources, though it has a powerfull C3 cache. The community site is highly active, providing strong support for questions about usage and configuration. Review collected by and hosted on G2.com.

Even though it is open source and part of the code is available on GitHub, they do not give importance to the community's efforts to collaborate with code modifications. Review collected by and hosted on G2.com.

I like the fact that you can query directly s3 and hdfs and it also support power bi as integration Review collected by and hosted on G2.com.

Its not etl friendly so I have to link it with apache ariflow Review collected by and hosted on G2.com.

The Reflections feature is awesome. It allows you to seamlessly accelerate queries by pre-aggregating query results at various aggregations that you can define over time, based on actual query usage. If you move away from Tableau, Dremio is how you can replace Tableau's Extract feature. Or, if you're using Superset, you can insert Dremio in between Superset and the data sources to auto-magically speed up slow queries and dashboards. Review collected by and hosted on G2.com.

Dremio OSS does not support encrypted ODBC or Flight connections. You need Enterprise for that. Review collected by and hosted on G2.com.

It supports mutiple clouds such as aws and azure for data manipulation. It has amazing data manipulation capabilities. Its data managing capabilities are really good it works amazing in that regard. The usage is also smooth and easy. It has totally modernized our data visualizing approach. Review collected by and hosted on G2.com.

We dont have that issue but it can be pricy for the new organizations or startups. Review collected by and hosted on G2.com.