Dremio AWS - BYOL
Dremio | 25.2.0Linux/Unix, Amazon Linux 2.0.20241014.0 - 64-bit Amazon Machine Image (AMI)
Reviews from AWS Marketplace
0 AWS reviews
-
5 star0
-
4 star0
-
3 star0
-
2 star0
-
1 star0
External reviews
External reviews are not included in the AWS star rating for the product.
An effective tool, with great enterprise support.
What do you like best about the product?
* 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.
* 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.
What do you dislike about the product?
* 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.
* 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.
What problems is the product solving and how is that benefiting you?
One tool that can query and combine all our data fast despite being stored in different locations with different formats.
- Leave a Comment |
- Mark review as helpful
A new way for simplification
What do you like best about the product?
Simplification – Single point of data access.
Data Blending – Merge diverse data pools easily
Protection – Enable security and authorization.
Acceleration – Performant reporting and analysis
Data Blending – Merge diverse data pools easily
Protection – Enable security and authorization.
Acceleration – Performant reporting and analysis
What do you dislike about the product?
Different roadmap AWS and Azure and not all capabilities you have in AWS are in Azure
What problems is the product solving and how is that benefiting you?
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
Dremio use the Data lake as a data source . From outside, Dremio looks and behaves like a relational Database
Dremio for Pon Equipment Pon Power, The Netherlands
What do you like best about the product?
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.
What do you dislike about the product?
The documentation on available functions is lacking. Dremio does not have a built-in Intellisense nor autosave.
What problems is the product solving and how is that benefiting you?
Virtual data warehousing directly on Microsoft CDM.
Data Virtualization
What do you like best about the product?
able to connect data from multiple sources via Native SQL
What do you dislike about the product?
Sharding work on individual executors can be improvise to keep it simple
What problems is the product solving and how is that benefiting you?
- Central Data virtualization
- Democratizing Data
- Technical edge
- Democratizing Data
- Technical edge
Self service Data lake acceleration
What do you like best about the product?
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.
The approach to self service through semantic engineering of data has created a new dimension to data analysis and data curation.
What do you dislike about the product?
Dremio's lack of support for database views and external decryption libraries, has created a perception that sometimes overshadows all the advantages it brings.
What problems is the product solving and how is that benefiting you?
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.
My Dremio experience as enterprise-wide data platform by big German client
What do you like best about the product?
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.
In case of any issues and challenges Dremio was very cooperative on Germany and global level to solve it.
What do you dislike about the product?
As Dremio do not implemented Elastic Engine on Azure we need to maintain Kubernetes cluster to reach out needed ad-hoc scale-out requirements.
What problems is the product solving and how is that benefiting you?
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.
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.
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)
..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)
Efficient and User Friendly SQL layer on top of open file format
What do you like best about the product?
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.
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.
What do you dislike about the product?
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.
What problems is the product solving and how is that benefiting you?
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.
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.
It is really a very fast analytic engine compare to other competitors
What do you like best about the product?
Setup and query execution also awse features, reflections
What do you dislike about the product?
Sometimes machines crashes due to aws upgrades
What problems is the product solving and how is that benefiting you?
Query execution is too fast around 7 times faster than athena
Strategic Partner
What do you like best about the product?
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.
What do you dislike about the product?
So far so good, they have been nothing but great partners.
What problems is the product solving and how is that benefiting you?
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.
Dremio as a Data Wrangling Tool
What do you like best about the product?
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.
What do you dislike about the product?
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
What problems is the product solving and how is that benefiting you?
A unified query layer to allow data exploration among disparate data sources
Recommendations to others considering the product:
Their docs are extremely thorough.
showing 51 - 60