License & Deployment Mix: 39 tools – 27 OSS, 12 SaaS. (OSS and SaaS counts can overlap when an open-source tool also offers a vendor-hosted edition.)

What Is a Data Warehouse?

A data warehouse is a centralized repository optimized for analytical queries across large volumes of structured data. Unlike transactional databases (OLTP) that handle fast reads and writes of individual records, data warehouses use columnar storage, compression, and pre-aggregation to deliver fast analytical performance over billions of rows.

Traditional data warehouses (Snowflake, BigQuery, Redshift) store structured, cleaned data loaded through ETL/ELT pipelines. They enforce schemas, optimize for aggregation queries, and serve as the single source of truth for business intelligence and reporting.

The information on these pages was researched by a combination of human review and large language models. To suggest an addition or correction, please contact us. Prepared by Rhodium Systems Inc., author of the ResorsIT platform — a unified IT operations management platform for IT teams and MSPs that integrates a curated suite of open-source, commercial, and SaaS applications into a single system with shared identity, single sign-on, access control, and a common audit trail. Use this catalogue only as a starting point for your own research, and review any tool carefully against your own requirements before relying on it. Catalogue data version 2026.197.

Comparison

This comparison covers the OLAP, ETL, lakehouse, and data catalog landscape.

SSO / OIDC Comparison

OIDC is the preferred SSO protocol; the notes below assume Authentik as the external identity provider.

* = via cloud provider identity federation

Best SSO support: Snowflake, Databricks, Starburst, Fivetran (OIDC + SAML + SCIM)

No built-in auth: DuckDB, DataFusion, dbt, Meltano, Singer (CLI or library tools)

Format specs: Iceberg, Delta Lake, Hudi, DuckLake, Paimon inherit auth from the engine or catalog that accesses them

API Comparison

DW Feature Comparison

Self-Hosted OLAP

Cloud / Commercial

Query Engine Comparison

Lakehouse Format Comparison

ETL / ELT Comparison

Self-Hosted

Cloud / Commercial

Data Catalog Comparison

Deployment Comparison

Licensing & Pricing

Tools

38 tools.

Airbyte

Airbyte is the leading data ingestion platform for building EL (extract-load) pipelines. It offers 350+ pre-built connectors covering databases, SaaS APIs, file formats, and event streams.

License: LicenseRef-Airbyte-ELv2 (source-available) · Kind: web · Deploy: docker, k8s, saas · SSO: none

Website

Amazon Redshift

Amazon Redshift is AWS’s fully managed cloud data warehouse service, launched in 2013. It was the first major cloud data warehouse and popularized the concept of elastic, pay-as-you-go analytical databases.

License: Proprietary (proprietary) · Kind: web · Deploy: saas · SSO: none

Website

Apache Airflow

Apache Airflow is the industry-standard workflow orchestrator for data pipelines. Originally created at Airbnb in 2014 and donated to the Apache Software Foundation, Airflow defines pipelines as Python code using DAGs (directed acyclic grap…

License: Apache-2.0 (OSS) · Kind: web · Deploy: native, docker, k8s · SSO: OIDC

Website · Source

Apache DataFusion

Apache DataFusion is an extensible query engine library written in Rust, designed to be embedded inside other applications and systems rather than deployed as a standalone service.

License: Apache-2.0 (OSS) · Kind: web · Deploy: k8s · SSO: none

Website · Source

Apache Doris

Apache Doris is a real-time analytical database with MySQL protocol compatibility, originally developed as Palo at Baidu and donated to the Apache Software Foundation in 2018.

License: Apache-2.0 (OSS) · Kind: web · Deploy: native · SSO: none

Website · Source

Apache Druid

Apache Druid is a real-time analytics database designed for sub-second OLAP queries on event- driven data. Originally created at Metamarkets and open-sourced in 2012, Druid became an Apache top-level project in 2018.

License: Apache-2.0 (OSS) · Kind: web · Deploy: native · SSO: none

Website · Source

Apache Hudi

Apache Hudi (Hadoop Upserts Deletes and Incrementals) is an open table format created at Uber to solve the problem of efficiently ingesting and managing rapidly changing datasets on data lakes.

License: Apache-2.0 (OSS) · Kind: web · Deploy: native · SSO: none

Website · Source

Apache Iceberg

Apache Iceberg is the leading open table format for large-scale analytical datasets, originally created at Netflix and donated to the Apache Software Foundation.

License: Apache-2.0 (OSS) · Kind: web · Deploy: saas · SSO: none

Website · Source

Apache NiFi

Apache NiFi is a visual data flow platform designed for real-time data routing, transformation, and system mediation.

License: Apache-2.0 (OSS) · Kind: web · Deploy: native, docker · SSO: OIDC

Website · Source

Apache Paimon

Apache Paimon is a streaming-first lakehouse table format that originated from the Apache Flink ecosystem. Originally developed as Flink Table Store, it was renamed to Apache Paimon and graduated to an Apache top-level project.

License: Apache-2.0 (OSS) · Kind: web · Deploy: native · SSO: none

Website · Source

Apache Pinot

Apache Pinot is a real-time distributed OLAP datastore designed for low-latency, high- throughput user-facing analytics.

License: Apache-2.0 (OSS) · Kind: web · Deploy: native · SSO: none

Website · Source

Apache Spark SQL

Apache Spark SQL is the SQL module of Apache Spark, the general-purpose distributed computing framework for large-scale data processing.

License: Apache-2.0 (OSS) · Kind: web · Deploy: native · SSO: none

Website · Source

Azure Synapse Analytics

Azure Synapse Analytics is Microsoft’s unified analytics service on Azure, combining enterprise data warehousing with big data analytics in a single platform.

License: Proprietary (proprietary) · Kind: web · Deploy: saas · SSO: none

Website

ClickHouse

ClickHouse is the fastest open-source columnar OLAP database, originally developed at Yandex for web analytics and open-sourced in 2016. It is written entirely in C++ and optimized for real-time analytical queries over billions of rows.

License: Apache-2.0 (OSS) · Kind: web · Deploy: native · SSO: none

Website · Source

Dagster

Dagster is an open-source data orchestrator built around software-defined assets, offering a visual asset graph, partitions, sensors, type checking, and strong dbt integration for data pipelines.

License: Apache-2.0 (OSS) · Kind: web · Deploy: native, docker, k8s · SSO: none

Website · Source

Databricks

Databricks is the leading lakehouse platform, combining data lake flexibility with data warehouse performance and governance.

License: Proprietary (proprietary) · Kind: web · Deploy: saas · SSO: OIDC

Website

DataHub

DataHub is an open-source metadata platform originally developed at LinkedIn and donated to the community under the Apache-2.0 license.

License: Apache-2.0 (OSS) · Kind: web · Deploy: docker, k8s, saas · SSO: none

Website · Source

dbt

dbt (data build tool) is the industry-standard SQL transformation framework for the “T” in ELT pipelines.

License: Apache-2.0 (OSS) · Kind: web · Deploy: native, docker · SSO: none

Website · Source

Delta Lake

Delta Lake is an open table format created by Databricks that adds ACID transactions, scalable metadata handling, and time travel to data stored as Parquet files on object storage.

License: Apache-2.0 (OSS) · Kind: web · Deploy: native · SSO: none

Website · Source

Dremio

Dremio is a lakehouse query engine built on Apache Arrow that provides SQL analytics directly on data lake storage without requiring data movement or ETL pipelines.

License: Apache-2.0 (OSS) · Kind: web · Deploy: native · SSO: OIDC

Website · Source

DuckDB

DuckDB is an in-process OLAP database engine, often described as “SQLite for analytics.” Unlike distributed query engines that require cluster infrastructure, DuckDB runs as an embedded library inside the host application process – no serv…

License: MIT (OSS) · Kind: web · Deploy: saas, docker · SSO: none

Website · Source

DuckLake

DuckLake is a lakehouse table format created by DuckDB Labs in 2025 that takes a fundamentally different approach to metadata management.

License: MIT (OSS) · Kind: web · Deploy: saas · SSO: none

Website · Source

Fivetran

Fivetran is the market-leading managed EL (extract-load) platform purpose-built for automated data replication into cloud data warehouses.

License: Proprietary (proprietary) · Kind: web · Deploy: saas · SSO: none

Website

Google BigQuery

Google BigQuery is a fully managed, serverless cloud data warehouse on Google Cloud, using the Dremel engine to query large datasets in SQL, with columnar storage, BigQuery ML, and BigLake governance.

License: Proprietary (proprietary) · Kind: web · Deploy: saas · SSO: none

Website

Greenplum

Greenplum is a massively parallel processing (MPP) analytical database built on PostgreSQL. Originally developed by Greenplum Inc.

License: Apache-2.0 (OSS) · Kind: web · Deploy: native · SSO: none

Website · Source

Matillion

Matillion is a visual ETL/ELT platform for cloud data warehouses such as Snowflake, BigQuery, Redshift, and Databricks, using pushdown transformation that compiles logic into warehouse-native SQL.

License: Proprietary (proprietary) · Kind: web · Deploy: saas · SSO: none

Website

Meltano

Meltano is a Singer-based ELT platform originally created by GitLab as an internal data integration tool and later spun out as an independent open- source project.

License: MIT (OSS) · Kind: web · Deploy: native, docker · SSO: none

Website · Source

MonetDB

MonetDB is a pioneering columnar analytical database developed at CWI (Centrum Wiskunde & Informatica) in Amsterdam, with research origins dating back to the 1990s.

License: MPL-2.0 (OSS) · Kind: web · Deploy: native · SSO: none

Website · Source

MotherDuck

MotherDuck is a serverless cloud analytics platform built on DuckDB, the open-source in- process analytical database.

License: Proprietary (proprietary) · Kind: web · Deploy: saas · SSO: none

Website

OpenMetadata

OpenMetadata is an open-source metadata platform that provides data discovery, lineage, governance, and data quality capabilities in a single unified platform.

License: Apache-2.0 (OSS) · Kind: web · Deploy: docker, k8s, saas · SSO: none

Website · Source

Prefect

Prefect is a Python-native workflow orchestrator designed to be simpler and more Pythonic than Airflow.

License: Apache-2.0 (OSS) · Kind: web · Deploy: native, docker, k8s · SSO: none

Website · Source

Presto

Presto is a distributed SQL query engine originally created at Facebook (Meta) in 2012 for interactive analytics over the Hive data warehouse.

License: Apache-2.0 (OSS) · Kind: web · Deploy: native · SSO: none

Website · Source

Singer

Singer is an open-source specification for data extraction and loading. It defines a JSON-based protocol for communication between “taps” (extractors that pull data from sources) and “targets” (loaders that push data to destinations).

License: AGPL-3.0-only (OSS) · Kind: web · Deploy: native, docker · SSO: none

Website · Source

Snowflake

Snowflake is the dominant independent cloud data warehouse platform, operating as a fully managed SaaS service across AWS, Azure, and GCP.

License: Proprietary (proprietary) · Kind: web · Deploy: saas · SSO: none

Website

Starburst

Starburst is the commercial distribution of Trino, created and maintained by the company founded by the original Trino creators.

License: Proprietary (proprietary) · Kind: web · Deploy: native · SSO: OIDC

Website

StarRocks

StarRocks is a high-performance analytical database designed for real-time, sub-second queries on large datasets.

License: Apache-2.0 (OSS) · Kind: web · Deploy: native · SSO: none

Website · Source

Stitch

Stitch is a managed data replication service owned by Qlik (acquired via Talend). It focuses on simple, reliable EL (extract-load) from SaaS applications and databases into cloud data warehouses.

License: Proprietary (proprietary) · Kind: web · Deploy: saas · SSO: none

Website

Trino

Trino is a distributed SQL query engine designed for interactive analytical queries across massive datasets and heterogeneous data sources.

License: Apache-2.0 (OSS) · Kind: web · Deploy: native · SSO: OIDC

Website · Source