22-25 April 2026

dbt → Cube.js → Superset: Automating Semantic Layer & BI Sync

Proposed session for SQLBits 2026

TL; DR

Learn how to automate a full semantic layer pipeline using dbt, Cube.js, and Superset. See how dbt-to-cube generates metrics, syncs them to BI tools, and eliminates manual metric duplication across dashboards.

Session Details

Manually rebuilding metric logic across multiple BI tools is one of the most persistent pain points in modern data engineering. In this session, we’ll walk through an automated dbt → Cube.js → Superset pipeline that keeps your semantic layer and BI datasets fully in sync—without touching a dashboard or writing schema files by hand.
You’ll see how a small open-source tool, dbt-to-cube, generates Cube.js schemas directly from dbt and pushes them to Superset (or Tableau/PowerBI), creating a unified, version-controlled semantic layer that updates automatically as your models evolve.
We’ll explore the architecture, live examples, and practical lessons learned from building this workflow.

Full blog post / reference: https://newsletter.ponder.co/p/dbt-cubejs-superset-automating-semantic

3 things you'll get out of this session

- Understand how to automate metric and dataset propagation from dbt → Cube.js → BI tools. - Learn how dbt-to-cube generates semantic models and keeps BI platforms in sync automatically. - Walk away with a reproducible setup (local or production) for maintaining a unified semantic layer with zero manual rework.