Open source alternatives to dbt

One project on starwire does the same job. Ranked by how much of what dbt does each one covers, read from its README and website. Ties go to the most active.

What dbt does

  1. SQL models that transform warehouse datacore
  2. Dependencies and run order between modelscore
  3. Data tests
  4. Generated docs and lineage
  5. Incremental models
  6. Macros and packages

Each dot in the table is one job, in this order. Square dots are core jobs and count double. Full means yes, half means partly. "See the evidence" under a project shows the line behind each one. Coverage is what a project documents, not how well it works or how hard it is to move to. How we score this

ProjectCoversStarsCommits, 12 weeksLast releaseClosed vs openedSetupLicense
rockySQL transformation engine that type-checks pipelines and tracks column lineage Replaces it81%311+2
613
4 days ago100% Uses the terminal Apache-2.0
Covers all 2 core jobs. Partly: Generated docs and lineage. Not shown: Macros and packages.See the evidence
  • SQL models that transform warehouse datacoreYesRocky checks your SQL models before they run
  • Dependencies and run order between modelscoreYesyour models and their DAG
  • Data testsYesChecks and declarative [[tests]]
  • Generated docs and lineagePartlyColumn-level lineage for PR review
  • Incremental modelsYesstrategy = "incremental"
  • Macros and packagesNot shownNeither the README nor the website mentions it.

Vital signs from GitHub, checked weekly. How we read these · How setup is read

All repos

New repos every two days, stars refreshed daily. Visits are counted without cookies, and the numbers are public. How it works Data RSS Newsletter

The best new open source, once a weekOne short email: the repo everyone is suddenly starring, a handful worth trying, and one hidden gem, each with a plain note on what it does. Free, with no tracking pixels.

Read past issues

↑ ↓ to move   Enter to choose   Esc to close

Follow starwire by RSSCopy an address into your feed reader.
The day's bestOne item a day: the repos rising fastest and the biggest new picks.starwire.foo/top.xml
Every new pickAll of them as they are added, up to 60 a day.starwire.foo/feed.xml
The weekly emailEach issue of the newsletter, once a week.list.starwire.foo/archive.xml