We use Dremio for data engineering.
Dremio AWS - BYOL
DremioExternal reviews
External reviews are not included in the AWS star rating for the product.
Dremio is an A game. I give it a solid 5 star rating.
Dremio enables us to get the most comprehensive and accurate insights from our data by making it easily possible to run in-depth analysis on the data.
Simple and easy to use but limited feature.
A modern Data Lake Platform
facilitates enhanced teamwork.
Dremio intelligent but hard to setup.
Modern Data Platform Analytics engine
Fastest way to get iceburg working
A highly stable solution that works like a data warehouse on top of data lakes
What is our primary use case?
How has it helped my organization?
Dremio has resolved my data lineage and data governance problems. The solution has also resolved the data availability for a different range of users, which used to be a problem.
What is most valuable?
Dremio allows querying the files I have on my block storage or object storage. The solution gives me a place where I can play around with the data virtually by creating VDSs or PDSs. Dremio works just like a data warehouse on top of my data lake, which is interesting.
What needs improvement?
Dremio's interface is good, but it has a few limitations. I cannot do a lot of things with ANSI SQL or basic SQL. I cannot use the recursive common table expression (CTE) in Dremio because the support page says it's currently unsupported.
The use case I am working on requires building trees and hierarchical structures. Most of the time, it requires complex nested data structures to be made simpler for end users. It would be good if Dremio could provide a way to create trees just like Oracle does using commands like CONNECT BY and NO CYCLE.
You can use a few languages to simplify complicated JSON and XML. It would be very helpful if Dremio could provide a solution to simplify building trees and building meaningful data from complex data.
What do I think about the stability of the solution?
I rate Dremio ten out of ten for stability.
What do I think about the scalability of the solution?
I rate Dremio ten out of ten for scalability.
How was the initial setup?
I rate Dremio ten out of ten for the ease of its initial setup.
What about the implementation team?
We implemented the solution through an in-house team. Dremio's deployment can be done quickly.
What other advice do I have?
Overall, I rate Dremio ten out of ten.
Quick database capabilities but sometimes shows minor errors
What is our primary use case?
I can visualize traffic from BI and Tableau on the same page and have my tables and schema on the same page. The data link comprises everything. If I want one structure, I connect it to a big table in the hive and the data team that could read my SQL work on my tables, schemas, table structures and everything all in one place. Dermio is as good as any other Presto engine.
How has it helped my organization?
Everyone uses Dremio in my company; some use it only for the analytics function.
What is most valuable?
The most valuable feature is that you can generate refresh reflections and create your visuals (VDS) because it makes it easier to monitor day-to-day data structure. I can use Dermio to create a visual table without impacting the original by creating an opportunity on my own. I can work on my videos and create reflections, and Dremio allows me to use those reflections. I can know the health of my tables, whether healthy or unhealthy, daily. It is one of the most valuable features of Dremio.
What needs improvement?
One of the areas of improvement is that a table does not break and shows errors. When the 23rd version was released, I had to contact Dermio customer support, and they suggested I update the database to run the table. Sometimes you face common errors like tables running strictly and taking time to run. I think Dermio can improve this part.
An additional feature can be a feature where everyone can see the tables.
For how long have I used the solution?
I have been using Dremio for over 3years now.
What do I think about the stability of the solution?
I would rate the scalability an 9/10 because it shows errors sometimes.
What do I think about the scalability of the solution?
I would rate the scalability a 10/10 based on its recent enhancements.
How are customer service and support?
We had Dremio support service at every point of time we requested it.
How would you rate customer service and support?
Positive
Which solution did I use previously and why did I switch?
Previously, I used Presto regularly.
How was the initial setup?
The initial setup was straightforward.
What about the implementation team?
The deployment was in-house, and only two to three people were involved. We had direct Dermio support communication to support us. We have both cloud and in-house deployment methods.
What was our ROI?
With Dremio its not a loss
What's my experience with pricing, setup cost, and licensing?
Every tool has a value based on its intended purpose and use, and the pricing is worth its value.
Which other solutions did I evaluate?
We tested some other options but Dremio proofs to be better in terms of reliability and scalability, so we submitted our reports and reviews.
What other advice do I have?
I suggest that you give it a try and see for yourself. Dremio is as fast as Presto. For example, ten billion rows can return in less than five seconds.
I would rate it a 10 out of 10.
Dremio Review
I am pleased about how easy it is to perform my job.