StackShareStackShare
Follow on
StackShare

Discover and share technology stacks from companies around the world.

Follow on

© 2025 StackShare. All rights reserved.

Product

  • Stacks
  • Tools
  • Feed

Company

  • About
  • Contact

Legal

  • Privacy Policy
  • Terms of Service
  1. Stackups
  2. Application & Data
  3. Databases
  4. Big Data Tools
  5. Dremio vs Kylo

Dremio vs Kylo

OverviewDecisionsComparisonAlternatives

Overview

Dremio
Dremio
Stacks116
Followers348
Votes8
Kylo
Kylo
Stacks15
Followers40
Votes0
GitHub Stars1.1K
Forks571

Dremio vs Kylo: What are the differences?

  1. Deployment Requirements: Dremio can be deployed on-premise, in the cloud, or as a managed service, providing flexibility in deployment options. In contrast, Kylo is designed for on-premise deployment only, limiting its deployment options for organizations looking for cloud-based solutions.
  2. User Interface: Dremio offers a sleek and intuitive user interface that simplifies data exploration and query execution for users. On the other hand, Kylo's user interface is more focused on data ingestion and preparation, with less emphasis on data exploration capabilities.
  3. Data Integration: Dremio provides advanced data integration capabilities, allowing users to easily connect and query multiple data sources without the need for complex configurations. In comparison, Kylo puts more emphasis on data ingestion workflows and does not offer the same level of flexibility for data integration.
  4. Data Governance: Dremio offers robust data governance features, including fine-grained access controls and auditing capabilities, to ensure data security and compliance. Kylo lacks the same level of data governance functionality, making it less suitable for organizations with strict regulatory requirements.
  5. Scalability: Dremio is highly scalable and can efficiently handle large volumes of data processing and analytical workloads. Kylo, while scalable to some extent, may face limitations in handling extremely large-scale data processing tasks, which can impact performance and user experience.
  6. Community Support: Dremio has a strong and active community of users and contributors, providing access to resources, documentation, and support forums. Kylo, on the other hand, has a smaller community and may have limited community-driven support resources available.

In Summary, Dremio offers greater deployment flexibility, a more user-friendly interface, advanced data integration capabilities, robust data governance features, scalability, and a stronger community support compared to Kylo.

Share your Stack

Help developers discover the tools you use. Get visibility for your team's tech choices and contribute to the community's knowledge.

View Docs
CLI (Node.js)
or
Manual

Advice on Dremio, Kylo

karunakaran
karunakaran

Consultant

Jun 26, 2020

Needs advice

I am trying to build a data lake by pulling data from multiple data sources ( custom-built tools, excel files, CSV files, etc) and use the data lake to generate dashboards.

My question is which is the best tool to do the following:

  1. Create pipelines to ingest the data from multiple sources into the data lake
  2. Help me in aggregating and filtering data available in the data lake.
  3. Create new reports by combining different data elements from the data lake.

I need to use only open-source tools for this activity.

I appreciate your valuable inputs and suggestions. Thanks in Advance.

80.4k views80.4k
Comments
datocrats-org
datocrats-org

Jul 29, 2020

Needs adviceonAmazon EC2Amazon EC2TableauTableauPowerBIPowerBI

We need to perform ETL from several databases into a data warehouse or data lake. We want to

  • keep raw and transformed data available to users to draft their own queries efficiently
  • give users the ability to give custom permissions and SSO
  • move between open-source on-premises development and cloud-based production environments

We want to use inexpensive Amazon EC2 instances only on medium-sized data set 16GB to 32GB feeding into Tableau Server or PowerBI for reporting and data analysis purposes.

319k views319k
Comments

Detailed Comparison

Dremio
Dremio
Kylo
Kylo

Dremio—the data lake engine, operationalizes your data lake storage and speeds your analytics processes with a high-performance and high-efficiency query engine while also democratizing data access for data scientists and analysts.

It is an open source enterprise-ready data lake management software platform for self-service data ingest and data preparation with integrated metadata management, governance, security and best practices inspired by Think Big's 150+ big data implementation projects.

Democratize all your data; Make your data engineers more productive; Accelerate your favorite tools; Self service, for everybody
Self-service data ingest with data cleansing, validation, and automatic profiling; Wrangle data with visual sql and an interactive transform through a simple user interface; Search and explore data and metadata, view lineage, and profile statistics; Monitor health of feeds and services in the data lake. Track SLAs and troubleshoot performance
Statistics
GitHub Stars
-
GitHub Stars
1.1K
GitHub Forks
-
GitHub Forks
571
Stacks
116
Stacks
15
Followers
348
Followers
40
Votes
8
Votes
0
Pros & Cons
Pros
  • 3
    Nice GUI to enable more people to work with Data
  • 2
    Easier to Deploy
  • 2
    Connect NoSQL databases with RDBMS
  • 1
    Free
Cons
  • 1
    Works only on Iceberg structured data
No community feedback yet
Integrations
Amazon S3
Amazon S3
Python
Python
Tableau
Tableau
Azure Database for PostgreSQL
Azure Database for PostgreSQL
Qlik Sense
Qlik Sense
PowerBI
PowerBI
ActiveMQ
ActiveMQ
Apache Spark
Apache Spark
Hadoop
Hadoop
Apache NiFi
Apache NiFi

What are some alternatives to Dremio, Kylo?

Google BigQuery

Google BigQuery

Run super-fast, SQL-like queries against terabytes of data in seconds, using the processing power of Google's infrastructure. Load data with ease. Bulk load your data using Google Cloud Storage or stream it in. Easy access. Access BigQuery by using a browser tool, a command-line tool, or by making calls to the BigQuery REST API with client libraries such as Java, PHP or Python.

Apache Spark

Apache Spark

Spark is a fast and general processing engine compatible with Hadoop data. It can run in Hadoop clusters through YARN or Spark's standalone mode, and it can process data in HDFS, HBase, Cassandra, Hive, and any Hadoop InputFormat. It is designed to perform both batch processing (similar to MapReduce) and new workloads like streaming, interactive queries, and machine learning.

Amazon Redshift

Amazon Redshift

It is optimized for data sets ranging from a few hundred gigabytes to a petabyte or more and costs less than $1,000 per terabyte per year, a tenth the cost of most traditional data warehousing solutions.

Qubole

Qubole

Qubole is a cloud based service that makes big data easy for analysts and data engineers.

Presto

Presto

Distributed SQL Query Engine for Big Data

Amazon EMR

Amazon EMR

It is used in a variety of applications, including log analysis, data warehousing, machine learning, financial analysis, scientific simulation, and bioinformatics.

Amazon Athena

Amazon Athena

Amazon Athena is an interactive query service that makes it easy to analyze data in Amazon S3 using standard SQL. Athena is serverless, so there is no infrastructure to manage, and you pay only for the queries that you run.

Apache Flink

Apache Flink

Apache Flink is an open source system for fast and versatile data analytics in clusters. Flink supports batch and streaming analytics, in one system. Analytical programs can be written in concise and elegant APIs in Java and Scala.

lakeFS

lakeFS

It is an open-source data version control system for data lakes. It provides a “Git for data” platform enabling you to implement best practices from software engineering on your data lake, including branching and merging, CI/CD, and production-like dev/test environments.

Druid

Druid

Druid is a distributed, column-oriented, real-time analytics data store that is commonly used to power exploratory dashboards in multi-tenant environments. Druid excels as a data warehousing solution for fast aggregate queries on petabyte sized data sets. Druid supports a variety of flexible filters, exact calculations, approximate algorithms, and other useful calculations.

Related Comparisons

Bootstrap
Materialize

Bootstrap vs Materialize

Laravel
Django

Django vs Laravel vs Node.js

Bootstrap
Foundation

Bootstrap vs Foundation vs Material UI

Node.js
Spring Boot

Node.js vs Spring-Boot

Liquibase
Flyway

Flyway vs Liquibase