The ease of which it allows you to quickly explore new data sets, is impressive. I am always in awe at how quickly we can consume huge data sets (folders full of CSV or Parquet files) and structure them to work as a single data table. This process would have typically taken an IT resource to create/apply a script to manipulate/load the data into a database or single file, and we have our "business" users with no IT experience doing it right away. They still rely on IT to write queries against it for them, but they can explore the data right away. With a little training, even our "business" users are writing SQL to explore the data.
We have a large-scale project to allow our entire organization access to the data they need to do their jobs. We had a large-scale ETL process that transforms that data into a data model and combines data generated inside our firm to data provided from our vendors. Adding Dremio into our environment meant that we no longer have to model the data provided by our vendors. We can spend more time modeling our internal data and running additional data quality checks instead of constantly adjusting our data model when we want to onboard new data from external vendors.
With personal spaces, our end users can upload a simple Excel document and join that to the data we have made available in our platform with no assistance from IT. And with the latest tools provided by the Dremio Professional Services, we now have the reports to show us what users are using what data sets! This allows us to constantly monitor our environment for bottlenecks and stale or unused data sets. This is a massive win for us! Review collected by and hosted on G2.com.
While Dremio has been a huge asset to the firm, there are several things that could be improved and there are some scenarios we have seen that it is not the appropriate tool for. We have an environment that has multiple storage accounts in the cloud and several databases that we connect to. We have had several performance issues when we combine data in our data lake to the databases. It turns processes into a single threaded query and essentially locks up or blocks all access to both the dremio environment and the database (Synapse in this case). Since implementing Dremio they have added Delta Lake support and we have turned to this to solve that issue. Since implementing Delta Lake instead of Synapse, we have essentially eliminated this issue.
As with any tool, there is a learning curve to the interface, the interface is rich and has a lot of features but lacks some usability aspects. We have provided feedback to Dremio on this and they have been attentive to these requests so I have confidence this will get better. Going from a typical SQL IDE like Management Studio is a bit of an adjustment, but you get used to it.
We user Power BI and to date, Dremio is not a first level provider for Power BI. You can connect and consume data from Dremio, but I cannot get information about what user is connecting, etc. I am waiting for MS to make them a first party provider. Review collected by and hosted on G2.com.
63 out of 64 Total Reviews for Dremio
Overall Review Sentiment for Dremio
Log in to view review sentiment.
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.
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.
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.
It handles big data well and supports SQL very easily when i start.
The performance improvements are noticeable easily.
It integrates with other tools which i use.
The data reflections feature enhances query speed and saves my times. Review collected by and hosted on G2.com.
Learning how to use it was hard for new user.
Setup took a long time.
Some features are not easy understand.
The interface could be more user friendly and with simple setup. Review collected by and hosted on G2.com.
Dremio is a game changing tools that enhance our consultation service company to provide client with all the forecast, data management, and data transformation that client require. Easy tools to operate is the main attraction and visualized analytics report tools help client understand data that we present. Running K8 deployment/setup is easy with the help from detailed documentation. Apache Hadoop integration simplify data distribution workflow. Review collected by and hosted on G2.com.
Bugs on every version that they releases. After one bugs is fixed on update, other is emerged and need to wait for hotfix or update. The problem keep cycles. Review collected by and hosted on G2.com.
With its In memoru Columnar engine we can process the data query at a very enhance speed. We use it with many data lakes but mostly with amzaon web services. Review collected by and hosted on G2.com.
The customersupport is quite limited. I dont have any issues apart from that. Review collected by and hosted on G2.com.
Been using Dremio for a year now and it has been game changer for big data management and data distribution . It keeps the data workflow going smoothly without any issue. Its best part is that it is totally scalable and very secure. I would definately recommend this tool. Review collected by and hosted on G2.com.
It has all the necessary required tools for managing big data but it is not beginner friendly and have steep learning curve. Review collected by and hosted on G2.com.
Mainly we use it for data visualization It pulls data from various sources we use aws cloud and NOSQL stores. Dremio accelerates query performance by storing query response. It saves time without any manual intervention. Its stupidly easy to use and overall efficient. Review collected by and hosted on G2.com.
Nothing as such i think its a complete package. Customer support surely can be improved a little tiny bit. Review collected by and hosted on G2.com.
