Bonobo vs Cube

Bonobo is a free, open-source ETL framework for Python developers building data transformation pipelines. It connects callable or iterable Python objects into directed graphs that it can visualize and execute. Data moves as streams of independent rows, with each node handling one row at a time while nodes can run in parallel. Transformations may be plain Python or transformation classes, organized as small units intended to support testing and maintenance. Built-in extractors and writers cover CSV, JSON, XML and XLS; the framework can also work with sources such as HTTP REST or SOAP APIs, filesystems, storage services, and SQL or NoSQL databases. The SQLAlchemy extension adds SQL database capabilities, while a Docker extension can run a local job with the bonobo runc command. Bonobo can also show live job status in a Jupyter Notebook. It is self-hosted, released under Apache License 2.0, and documented for small-scale data use. The documentation identifies it as alpha, so APIs may change.

Cube is an analytics platform with a semantic layer that encodes governed business definitions for dashboards, embedded applications, and AI agents. Cube Cloud supports internal business intelligence and embedded analytics, while Cube Core is the open-source project alongside which the cloud platform is built. The Free plan includes a semantic layer IDE, workbooks, dashboard publishing, semantic model and workbook agents, and analytics chat. Listed data sources include PostgreSQL, Snowflake, ClickHouse, Databricks, BigQuery, MySQL, Oracle, Redshift, MongoDB, and Trino; integrations include dbt, Dagster, Prefect, Airflow, and Coalesce.io. Cube Core processes API requests using pre-aggregated data in Cube Store or raw data in connected databases. Cloud deployment options include a managed multi-tenant service on AWS or GCP, a VPC on AWS, GCP, or Azure, and a customer's cloud through BYOC. Cube lists a free plan, Starter at $40 a month per developer, and Premium at $80 a month per developer.