Sign in
Categories
Your Saved List Become a Channel Partner Sell in AWS Marketplace Amazon Web Services Home Help

Dremio Enterprise

Dremio | 24.3.6

Linux/Unix, Amazon Linux 2.0.20240503.0 - 64-bit Amazon Machine Image (AMI)

Reviews from AWS Marketplace

0 AWS reviews
  • 5 star
    0
  • 4 star
    0
  • 3 star
    0
  • 2 star
    0
  • 1 star
    0

External reviews

48 reviews
from G2

External reviews are not included in the AWS star rating for the product.


    Mark Z.

Made us rethink our whole architecture!

  • April 30, 2021
  • Review verified by G2

What do you like best about the product?
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!
What do you dislike about the product?
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.
What problems is the product solving and how is that benefiting you?
We were trying to solve a data virtualization issue. We wanted to disconnect the data we provide to our end users from the physical data sources we get the data. Using the best practices of Dremio, we have been able to accomplish this and have already benefited from this. We were able to adjust from providing data from a Synapse instance to Delta Lake with zero impact to our end users and did not have change any of our queries.

Another side benefit of using Dremio is the time to market of our external data. We are able to quickly onboard sample data from the vendor and allow end users to explore this to determine if this is something they wish to pay for. We can then automate the feed of that data very quickly and make it immediately available.


    Laurentiu M.

Turn on the lights on the data lake

  • April 29, 2021
  • Review verified by G2

What do you like best about the product?
The best thing about Dremio is that it's very easy to use from the start. And then the more you work with it, the more you discover, you see that it's also really powerful as a query engine, as a data catalog, and as a query accelerator.

Beyond the software itself, the company is very cool. The people are very smart, knowledgeable, and always helpful.
What do you dislike about the product?
I think there's room for improvement in surfacing error messages to users.
What problems is the product solving and how is that benefiting you?
We are making it easy to analyze the data from our data lake and quickly surface data in some other databases.


    Leisure, Travel & Tourism

Next Generation SQL Engine

  • April 27, 2021
  • Review verified by G2

What do you like best about the product?
Dremio offers amazing SQL performance for our Cloud Data Lake
The UI is intuitive and offers some nice data preparation capabilities
Dremio's data strategy aligns with ours
Arrow Flight will offer a step-change in capability
What do you dislike about the product?
Dremio's user documentation is lagging behind their capabilities
Dremio has some hard limits on the numbers of columns and fields that need to be raised to cover all use cases
What problems is the product solving and how is that benefiting you?
Dremio is the foundation layer in our Analytics Stack, providing direct SQL access to PB of data and connectivity to advanced Analytic, ML and data visualisation tools. It's supporting our strategy to reduce/ eliminate the need for specialised data warehouse technology


    Borut H.

Senior Data Engineer

  • April 26, 2021
  • Review verified by G2

What do you like best about the product?
Simplicity of use and power of window functions.
What do you dislike about the product?
Lack of Undo and Redoo buttons in web user interface.
What problems is the product solving and how is that benefiting you?
Dremio is used to query large amount of data retrieved from production lines.


    Klemen S.

Simplify Data Engineering.

  • April 23, 2021
  • Review verified by G2

What do you like best about the product?
SQL API to all the data on the data lake.
What do you dislike about the product?
I needed a DevOps person to take care of deployment.
What problems is the product solving and how is that benefiting you?
It is enabling data access to data scientists.


    eric a.

Dremio is awesome!!!

  • April 08, 2021
  • Review verified by G2

What do you like best about the product?
It is fast, easy to use, has a great community, and very powerful in terms of what it delivers, namely data aggregation, access, and usage for analytics.
What do you dislike about the product?
Dremio can appear to have a steep learning curve, but it isn't so bad.
What problems is the product solving and how is that benefiting you?
We're querying massive amounts of data stored in different places. We've realized our previous process was costing us a lot and that we should have adopted Dremio sooner.


    Information Technology and Services

Accelerating Client Resiliency through enabling data driven insights

  • April 02, 2021
  • Review verified by G2

What do you like best about the product?
Intuitive, effective and transformative. Dremio enables us to provide quicker time to insights for our clients and internal uses. The tool is very user friendly. Their support team is awesome and always super helpful as well. Personal experience through the Dremio Support and Sales teams and open to feedback. The tool supports alot of downstream connections and usage through its API and JDBC/ODBC connection which we use to visualize and present insights to our clients and customers.
What do you dislike about the product?
Limited Data Source Connections is something we constant run into issues with. RBAC would be a great feature as well since single sign on through AAD doesnt keep credentials just gives access to the platform. Also difficult to see the logs without putting in some extra effort to find them. Dremio is still developing and we understand that some of these dislikes are currently being resolved through the course of the products development.
What problems is the product solving and how is that benefiting you?
We are helping organizations be more resilient through black swan events by driving and guiding their data insights and actions based on data. We have realized quicker time to pull data together and perform analysis to drive decisions. This has saved clients money and time on a regular basis! We are seeing great interest in our clients to solve issues around siloed data, duplicate data, non democrotized reporting data and insights. The need to standardize the approach to data and govern and access in a consistent manner.


    Gurdeep S.

Data Lake Adoption

  • December 04, 2020
  • Review verified by G2

What do you like best about the product?
Enabling interactive speed queries on Hadoop
What do you dislike about the product?
Can be misused as a mainstream ELT tool.
What problems is the product solving and how is that benefiting you?
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


    Financial Services

User friendly self servicing Data lake engine

  • November 30, 2020
  • Review provided by G2

What do you like best about the product?
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.
What do you dislike about the product?
Nothing major but it would be great if Dremio can offer connectors to more legacy data sources
What problems is the product solving and how is that benefiting you?
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.


    Bert K.

A virtual integration environment to allow data analyzing on a higher and faster level

  • November 30, 2020
  • Review provided by G2

What do you like best about the product?
Easy to use, SQL based, No data movement, optimizing and integrate queries and/or the use of reflections for a high analyzing performance
What do you dislike about the product?
At this moment no actual issues, maybe a missing data dictionary
What problems is the product solving and how is that benefiting you?
No data movement, self service analytics