Dremio vs Knowage comparison

Cancel
You must select at least 2 products to compare!
Dremio Logo
2,683 views|2,043 comparisons
100% willing to recommend
Knowage Logo
941 views|752 comparisons
85% willing to recommend
Comparison Buyer's Guide
Executive Summary

We performed a comparison between Dremio and Knowage based on real PeerSpot user reviews.

Find out what your peers are saying about Databricks, Microsoft, Alteryx and others in Data Science Platforms.
To learn more, read our detailed Data Science Platforms Report (Updated: May 2024).
771,212 professionals have used our research since 2012.
Featured Review
AbdulshukoorMohammed
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"Dremio gives you the ability to create services which do not require additional resources and sterilization.""The most valuable feature of Dremio is it can sit on top of any other data storage, such as Amazon S3, Azure Data Factory, SGFS, or Hive. The memory competition is good. If you are running any kind of materialized view, you'd be running in memory.""Dremio allows querying the files I have on my block storage or object storage.""Everyone uses Dremio in my company; some use it only for the analytics function.""Dremio enables you to manage changes more effectively than any other data warehouse platform. There are two things that come into play. One is data lineage. If you are looking at data in Dremio, you may want to know the source and what happened to it along the way or how it may have been transformed in the data pipeline to get to the point where you're consuming it.""We primarily use Dremio to create a data framework and a data queue."

More Dremio Pros →

"I can't name the features the way the Knowage community calls them because I still don't know the lingo. However, I can describe them. I like the ability to join more than one report, set all fields on one end, and replicate that on the other reports. I like that a lot. I think it's one of the features that got me using Knowage. They have tables, and I like that too. They took SQL scripts and many other scripts and enabled them to even correlate with Python. That's also one of the best things about Knowage. You could also decide to get information per user role, and this is also a feature that I like in Knowage.""The concept of engines is quite powerful allowing the user to work with report authoring/provisioning tools of their choice.""The embedding feature is great.""We can easily do our own customizations."

More Knowage Pros →

Cons
"It shows errors sometimes.""We've faced a challenge with integrating Dremio and Databricks, specifically regarding authentication. It is not shaking hands very easily.""They have an automated tool for building SQL queries, so you don't need to know SQL. That interface works, but it could be more efficient in terms of the SQL generated from those things. It's going through some growing pains. There is so much value in tools like these for people with no SQL experience. Over time, Dermio will make these capabilities more accessible to users who aren't database people.""Dremio doesn't support the Delta connector. Dremio writes the IT support for Delta, but the support isn't great. There is definitely room for improvement.""Dremio takes a long time to execute large queries or the executing of correlated queries or nested queries. Additionally, the solution could improve if we could read data from the streaming pipelines or if it allowed us to create the ETL pipeline directly on top of it, similar to Snowflake.""I cannot use the recursive common table expression (CTE) in Dremio because the support page says it's currently unsupported."

More Dremio Cons →

"The only challenge here is that it's a Java-based platform. It requires very high technical skills.""Development of SpagoBI has now been moved to Knowage. Users interested in further developments of the platform will have to look there.""The dashboard components could be better.""It would be better if more resources were available to help us learn how to use it. I wanted to use Knowage for a more extended period, but learning materials around the product were not really available and were not really straightforward. I've also seen inconsistencies between versions. For example, under the tools, especially in the cockpit, the way you create reports is now different. You will also find some configurations within a particular state, like a line chart, which differs from version to version. I think consistency is an essential feature in a product, especially for business intelligence products."

More Knowage Cons →

Pricing and Cost Advice
  • "Right now the cluster costs approximately $200,000 per month and is based on the volume of data we have."
  • "Dremio is less costly competitively to Snowflake or any other tool."
  • More Dremio Pricing and Cost Advice →

  • "It allows the implementation of an effective reporting system using internal skills at a limited upfront cost."
  • "Knowage is open-source, and an enterprise edition is also available."
  • More Knowage Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Data Science Platforms solutions are best for your needs.
    771,212 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:Dremio allows querying the files I have on my block storage or object storage.
    Top Answer:Every tool has a value based on its visualization, and the pricing is worth its value.
    Top Answer: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… more »
    Ask a question

    Earn 20 points

    Ranking
    9th
    Views
    2,683
    Comparisons
    2,043
    Reviews
    6
    Average Words per Review
    530
    Rating
    8.7
    23rd
    out of 50 in Reporting
    Views
    941
    Comparisons
    752
    Reviews
    0
    Average Words per Review
    0
    Rating
    N/A
    Comparisons
    Also Known As
    SpagoBI
    Learn More
    Dremio
    Video Not Available
    Overview

    Dremio is a data analytics platform designed to simplify and expedite the data analysis process by enabling direct querying across multiple data sources without the need for data replication. This solution stands out due to its approach to data lake transformation, offering tools that allow users to access and query data stored in various formats and locations as if it were all in a single relational database.

    At its core, Dremio facilitates a more streamlined data management experience. It integrates easily with existing data lakes, allowing organizations to continue using their storage of choice, such as AWS S3, Microsoft ADLS, or Hadoop, without data migration. Dremio supports SQL queries, which means it seamlessly integrates with familiar BI tools and data science frameworks, enhancing user accessibility and reducing the learning curve typically associated with adopting new data technologies.

    What Are Dremio's Key Features?

    • Data Reflections: Reduces query times by creating optimized representations of source data, which can accelerate performance without the complexity of traditional data warehousing solutions.
    • Semantic Layer: Allows users to define business metrics and dimensions centrally, ensuring consistency and governance across all analytics tools.
    • Built-in Security Features: Provides robust security measures, including column- and row-level security, ensuring compliance with data governance and privacy standards.
    • Support for Multiple Data Formats and Sources: Enables querying directly against a variety of data formats (Parquet, JSON, etc.) and sources without the need for conversion or replication.

    What Benefits Should Users Expect?

    When evaluating Dremio, potential users should look for feedback on its query performance, especially in environments with large and complex data sets. Reviews might highlight the efficiency gains from using Dremio’s data reflections and its ability to integrate with existing BI tools without significant changes to underlying data structures. Also, check how other users evaluate its ease of deployment and scalability, particularly in hybrid and cloud environments.

    How is Dremio Implemented Across Different Industries?

    Dremio is widely applicable across various industries, including finance, healthcare, and retail, where organizations benefit from rapid, on-demand access to large volumes of data spread across disparate systems. For instance, in healthcare, Dremio can be used to analyze patient outcomes across different data repositories, improving treatment strategies and operational efficiencies.

    What About Dremio’s Pricing, Licensing, and Support?

    Dremio offers a flexible pricing model that caters to different sizes and types of businesses, including a free community version for smaller teams and proof-of-concept projects. Their enterprise version is subscription-based, with pricing varying based on the deployment scale and support needs. Customer support is comprehensive, featuring dedicated assistance, online resources, and community support.

    Knowage (formerly SpagoBI) has a 14-years history. The actual release is the 6.3.

    Knowage offers FULL ANALYTICAL CAPABILITIES, with a special focus on big data analytics and comprehensive support to rich and multi-source data analysis. Knowage provides different modules, each one focused on a specific domain but mutually combinable (Big Data, Smart Intelligence, Enterprise Reporting, Location Intelligence, Performance Management, Predictive Analysis). Moreover, Knowage is an OPEN SOURCE solution: the source code is freely accessible, everyone is allowed to join the community and build the own business solution to ensure strategic decision-making and improved productivity.

    Knowage suite is supported by Engineering Group, the leading Italian software and services company, with about 10,000 people and more than 50 offices worldwide. Maintenance and support services (such as trainings, migration support, proof-of-concepts, etc) are provided by Engineering Group (KNOWAGE Labs) under subscription.

    Sample Customers
    UBS, TransUnion, Quantium, Daimler, OVH
    FIAT Group, Italian air navigation service provider, Ministry of Education and Science of the Russian Federation, Telecom Italia, ASL Genovese, San Giovanni Battista University Hospital
    Top Industries
    VISITORS READING REVIEWS
    Financial Services Firm31%
    Computer Software Company11%
    Manufacturing Company8%
    Retailer4%
    REVIEWERS
    Comms Service Provider25%
    Computer Software Company25%
    Healthcare Company13%
    Hospitality Company13%
    VISITORS READING REVIEWS
    Computer Software Company19%
    Government11%
    Real Estate/Law Firm11%
    Hospitality Company6%
    Company Size
    VISITORS READING REVIEWS
    Small Business16%
    Midsize Enterprise11%
    Large Enterprise73%
    REVIEWERS
    Small Business37%
    Midsize Enterprise32%
    Large Enterprise32%
    VISITORS READING REVIEWS
    Small Business32%
    Midsize Enterprise21%
    Large Enterprise47%
    Buyer's Guide
    Data Science Platforms
    May 2024
    Find out what your peers are saying about Databricks, Microsoft, Alteryx and others in Data Science Platforms. Updated: May 2024.
    771,212 professionals have used our research since 2012.

    Dremio is ranked 9th in Data Science Platforms with 6 reviews while Knowage is ranked 23rd in Reporting. Dremio is rated 8.6, while Knowage is rated 7.6. The top reviewer of Dremio writes "It enables you to manage changes more effectively than any other platform". On the other hand, the top reviewer of Knowage writes "Easy to customize, cross-platform capable, and very stable". Dremio is most compared with Databricks, Snowflake, Starburst Enterprise, Amazon Redshift and Microsoft Azure Synapse Analytics, whereas Knowage is most compared with Microsoft Power BI, Tableau, Pentaho Business Analytics and SAP BusinessObjects Business Intelligence Platform.

    We monitor all Data Science Platforms reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.