← Back to home
Comparison · Analytics

Citus vs dbt Core

A side-by-side editorial comparison of Citus and dbt Core — release velocity, themes, recent moves, and the top alternatives to consider.

Citus vs dbt Core: at a glance

FeatureCitusdbt Core
SectorAnalyticsAnalytics
Velocity score2.56.3
Sparks · 30d00
Top themespostgres, distributed-sql, maintenance-branches, backportsfusion-migration, v2-transition, semantic-layer, adapters
Last editorial update2mo ago14d ago
WebsiteVisit →Visit →

What is Citus?

Citus is in maintenance mode across four branches, with the feature work invisible from the feed.

Citus is the Postgres extension that shards tables across a cluster, and its release feed right now is almost entirely branch upkeep. Four lines are live at once — 12.1, 13.3, 14.0 and 14.1 — and the recent tags are backports and CI fixes moving between them, authored by a small handful of maintainers. The last release with user-facing feature text is Citus 14.0 in February, which added PostgreSQL 18.1 support and pointed at a blog post rather than listing what changed.

Read the full Citus trajectory →

What is dbt Core?

dbt's 1.x releases now point users at v2 straight from the command line.

dbt 2.0 GA split the project into a proprietary 'dbt' binary and dbt-oss, and the 2.0 dev channel has since added read-only Databricks Unity Catalog access through Lake Compute. The 1.x line is still shipping: 1.13.0b1 adds an opt-in --use-v2-parser that hands parsing to the Fusion parser, and today's 1.12.6 prints a v2 availability notice on dbt --version and relays Fusion parser logs through the otel log format.

Read the full dbt Core trajectory →

Citus vs dbt Core: editorial side-by-side

C
Citus
ANALYTICS
2.5

Citus is in maintenance mode across four branches, with the feature work invisible from the feed.

◆ Current state

Citus is the Postgres extension that shards tables across a cluster, and its release feed right now is almost entirely branch upkeep. Four lines are live at once — 12.1, 13.3, 14.0 and 14.1 — and the recent tags are backports and CI fixes moving between them, authored by a small handful of maintainers. The last release with user-facing feature text is Citus 14.0 in February, which added PostgreSQL 18.1 support and pointed at a blog post rather than listing what changed.

◆ Where it's heading

The shape here is a mature extension keeping several supported branches alive rather than pushing new capability. Correctness is the live concern: the 12.1 patches fix wrong query results, an EXPLAIN segfault, a standby coordinator crash and a deadlock, all backported from work done on newer branches. Note that the release notes are thin by design — 13.3 and 14.1 list only PR titles for backports and test plumbing, so the feed understates whatever is landing on the main line.

◆ Prediction

More 12.1 patch tags are the safe expectation while that branch stays supported. Whether the 14.x line picks up new distributed-query features is not visible from these entries — the notes only cover backports, so the main-branch work would have to be read elsewhere.

D
dbt Core
ANALYTICS
6.3

dbt's 1.x releases now point users at v2 straight from the command line.

◆ Current state

dbt 2.0 GA split the project into a proprietary 'dbt' binary and dbt-oss, and the 2.0 dev channel has since added read-only Databricks Unity Catalog access through Lake Compute. The 1.x line is still shipping: 1.13.0b1 adds an opt-in --use-v2-parser that hands parsing to the Fusion parser, and today's 1.12.6 prints a v2 availability notice on dbt --version and relays Fusion parser logs through the otel log format.

◆ Where it's heading

The 1.x branch is being turned into an on-ramp for v2: a PyPI banner in 1.12.5, a CLI notice in 1.12.6, deprecated-version warnings and the Fusion parser opt-in in 1.13. Meanwhile 2.0 work concentrates on adapter parity (ClickHouse, Databricks) and Lake Compute.

◆ Prediction

Expect 1.13 to reach GA with the v2 parser opt-in and more migration prompts, and 2.0.x to extend Lake Compute past read-only Unity access. The entries don't show an end-of-life date for 1.x.

Alternatives to Citus and dbt Core

Other Analytics products tracked by Sparkpulse, ranked by recent ship velocity. Each card links to a full editorial trajectory and lets you pivot into a head-to-head comparison with either Citus or dbt Core.

See all Citus alternatives → · See all dbt Core alternatives →

Recent activity from Citus and dbt Core

Latest ship moves from both products, interleaved chronologically. ⚡ = editorial spark.

  1. 15d agodbt Coredbt 1.12.6 points users to v2 and fixes Fusion parser logging
  2. 15d agodbt Coredbt 1.11.16 fixes nested wildcard selectors, adds tarball path check
  3. 15d agodbt Coredbt-core 1.13 beta adds opt-in Fusion parser and dbt login
  4. 1mo agodbt CoreLake Compute gains Databricks Unity Catalog read access
  5. 1mo agodbt Coredbt v2.0.0 ⚡
  6. 1mo agodbt Coredbt v1.12.5
  7. 2mo agoCitus12.1.14 fixes wrong results, an EXPLAIN segfault and a standby crash
  8. 3mo agoCitusCitus 14.1 ships as a backport and CI maintenance release
  9. 4mo agoCitus12.1.13 fixes a deadlock, crashes and internal UDF ownership
  10. 4mo agoCitusCitus 13.3 lands as a backport-only release on the 13.x line
  11. 8mo agoCitusCitus 14.0 adds PostgreSQL 18.1 support

Frequently asked questions

What is the difference between Citus and dbt Core?

They serve adjacent needs but don't currently overlap on shipped themes. dbt Core is currently shipping more aggressively (velocity 6.3 vs 2.5), with 0 editorial sparks in the last 30 days against 0. See the at-a-glance table above for a side-by-side breakdown of velocity, recent sparks, and editorial themes.

Is Citus better than dbt Core?

Sparkpulse doesn't pick a winner — we score release velocity, not feature parity. dbt Core is currently shipping more aggressively (velocity 6.3 vs 2.5), with 0 editorial sparks in the last 30 days against 0. For your specific use case, the alternatives sections above list other Analytics products to evaluate alongside.

What are the best alternatives to Citus?

Top Citus alternatives in Analytics are ranked by recent ship velocity. Browse the "Citus alternatives" section above for the current picks, or visit /alternatives/citus for the full list with editorial commentary on each.

What are the best alternatives to dbt Core?

Top dbt Core alternatives in Analytics are ranked by recent ship velocity. Browse the "dbt Core alternatives" section above for the current picks, or visit /alternatives/dbt-core for the full list with editorial commentary on each.