Data and analytics

Comparisons of open-source data and analytics tools: metadata catalogs, pipeline orchestrators, BI and dashboard tools, and analytical versus general-purpose databases.

Apache Superset

Comparisons that start from Apache Superset, the Apache-2.0 BI platform with a SQL IDE and no-code chart builder, against other self-hosted dashboard and BI tools.

Metabase

Comparisons anchored on Metabase, the self-serve BI tool with an AGPL open-source edition and paid Pro and Enterprise plans.

Apache Airflow

Comparisons that start from Apache Airflow, the Apache-2.0 workflow scheduler, against newer Python orchestrators, now that Airflow 2 has reached end of life.

OpenMetadata

Comparisons anchored on OpenMetadata, the Apache-2.0 metadata catalog for discovery, lineage and governance.

ClickHouse

Comparisons anchored on ClickHouse, the Apache-2.0 column-oriented database for analytics, against general-purpose databases teams already run.

Dagster

Comparisons that start from Dagster, the Apache-2.0 asset-based data orchestrator with a paid Dagster+ cloud, against other Python-native orchestrators.

Prefect

Comparisons anchored on Prefect, the Apache-2.0 Python workflow orchestrator with a self-hosted server and the managed Prefect Cloud, against other self-hosted orchestrators.

Apache Druid

Comparisons anchored on Apache Druid, the Apache-2.0 real-time analytics database from the Apache Software Foundation, against other real-time OLAP engines.

Data and analytics compared

Roundups of open-source data and analytics tools by job: BI and dashboards, pipeline orchestration and real-time analytical databases, each judged on license, architecture and what it takes to self-host.

DataHub

Comparisons anchored on DataHub, the Apache-2.0 metadata platform for discovery, lineage and governance, which its maker also sells as the managed DataHub Cloud.

StarRocks

Comparisons anchored on StarRocks, the Apache-2.0 MPP analytics database and Linux Foundation project that runs shared-nothing or shared-data on object storage.

DuckDB

Comparisons anchored on DuckDB, the MIT-licensed embedded analytical database, against databases and engines teams already run.

Trino

Comparisons anchored on Trino, the Apache-2.0 distributed SQL query engine (formerly PrestoSQL) that queries lakehouses and databases in place.

Apache Spark

Comparisons anchored on Apache Spark, the Apache-2.0 engine for data engineering, SQL, streaming and machine learning on clusters.

Apache Iceberg

Comparisons anchored on Apache Iceberg, the Apache-2.0 open table format for analytic tables shared by Spark, Trino, Flink and other engines.

TimescaleDB

Comparisons anchored on TimescaleDB, the PostgreSQL extension for time-series analytics with an Apache 2 Edition, a Timescale License Community Edition and Tiger Cloud.

dbt Core

Comparisons anchored on dbt, the SQL transformation framework from dbt Labs, against other open-source transformation tools and its own hosted platform.

Talk to our team.

Tell us what you're working on, whether it's a deployment, an audit, a security test or a cyber range. You'll speak with an engineer who can help you scope it.

  • 30-minute call: free, with no obligation.
  • NDA on request: we can sign before you share details.
  • Clear next steps: a scope and plan after the call.
Book a callhello@deployopen.com