← Back to home
Comparison · Analytics

dbt Core vs OpenCTI

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

dbt Core vs OpenCTI: at a glance

Featuredbt CoreOpenCTI
SectorAnalyticsAnalytics
Velocity score7.55.0
Sparks · 30d20
Top themesdata-transformation, lakehouse, iceberg, dual-enginethreat-intelligence, connector-marketplace, workflow-approval, sbom
Last editorial update3d ago3h ago
WebsiteVisit →Visit →

What is dbt Core?

Two engines in one repo: the Python 1.x line tightens while Fusion 2.0 goes lakehouse-catalog native

dbt-core is releasing on two tracks at once. The Python line reached 1.12.0 on 16 July after three release candidates, and it is a tightening release: the experimental `dbt login` command and the bundled dbt-state plugin were removed outright, and flags introduced in 1.9 and 1.10 now default to true. The 2.0.0 alpha track is the Fusion engine, and its work is almost entirely about catalogs — read-write Horizon and Unity access over Iceberg REST via DuckDB, a catalogs.yml v2 covering DuckLake, Iceberg REST and local filesystem, plus catalog_database overrides and Redshift catalog generation through SHOW TABLES and SVV_REDSHIFT_COLUMNS.

Read the full dbt Core trajectory →

What is OpenCTI?

OpenCTI ships weekly and is rebuilding its connector catalog into a marketplace.

OpenCTI runs a weekly CalVer release train on the current line plus a separate LTS branch that takes backported security work. The recurring theme across recent releases is the integrations surface: the connector catalog was redesigned into a faceted marketplace, connector status labels were renamed to Supported by Filigran and Supported by Community, and the new integrations experience closed its functional gaps around config import, works, sorting and next-run visibility. Workflow gained draft approval, full reset and protection against publishing a workflow that deletes an in-use status, and the legacy HTML editor was removed outright.

Read the full OpenCTI trajectory →

dbt Core vs OpenCTI: editorial side-by-side

D
dbt Core
ANALYTICS
7.5

Two engines in one repo: the Python 1.x line tightens while Fusion 2.0 goes lakehouse-catalog native

◆ Current state

dbt-core is releasing on two tracks at once. The Python line reached 1.12.0 on 16 July after three release candidates, and it is a tightening release: the experimental `dbt login` command and the bundled dbt-state plugin were removed outright, and flags introduced in 1.9 and 1.10 now default to true. The 2.0.0 alpha track is the Fusion engine, and its work is almost entirely about catalogs — read-write Horizon and Unity access over Iceberg REST via DuckDB, a catalogs.yml v2 covering DuckLake, Iceberg REST and local filesystem, plus catalog_database overrides and Redshift catalog generation through SHOW TABLES and SVV_REDSHIFT_COLUMNS.

◆ Where it's heading

The division of labour between the two tracks is clear from the entries: 1.x is consolidating and removing experiments, while 2.0 is where the new surface area lands. The 2.0 surface is specifically the lakehouse catalog layer — dbt is moving from a tool that writes to a warehouse toward one that binds to open table catalogs directly, with materialization made catalog-aware. Notably 1.12.0rc1 also teaches the Python engine to tolerate Fusion-specific warn_error_options rather than erroring, so the two engines are being made to coexist in the same projects rather than fork.

◆ Prediction

The alphas are still expanding catalog coverage adapter by adapter, so expect further catalog integrations and continued catalogs.yml v2 work before 2.0 leaves alpha. On the Python side, with the deprecated flags now defaulted and the experimental commands removed, 1.12 looks like a stabilization point rather than a base for new features.

O
OpenCTI
ANALYTICS
5.0

OpenCTI ships weekly and is rebuilding its connector catalog into a marketplace.

◆ Current state

OpenCTI runs a weekly CalVer release train on the current line plus a separate LTS branch that takes backported security work. The recurring theme across recent releases is the integrations surface: the connector catalog was redesigned into a faceted marketplace, connector status labels were renamed to Supported by Filigran and Supported by Community, and the new integrations experience closed its functional gaps around config import, works, sorting and next-run visibility. Workflow gained draft approval, full reset and protection against publishing a workflow that deletes an in-use status, and the legacy HTML editor was removed outright.

◆ Where it's heading

Two directions are visible. One is commercial packaging — XTM Hub connection points, hero-style Enterprise Edition cards in settings, and the supported-by labelling all draw a line between vendor-backed and community connectors inside the product. The other is supply-chain and governance hygiene: SBOM generation with syft, documented SBOM format, admin-forced password changes, session IDs recorded in audit logs, and a configurable webhook deny list. The LTS branch confirms the split audience — enterprises on a slow line getting CVE backports while the weekly line moves.

◆ Prediction

Expect the marketplace framing to keep hardening the commercial boundary — paid or vendor-supported connectors surfaced distinctly from community ones — and workflow approval to extend from drafts into other publishing paths.

Alternatives to dbt Core and OpenCTI

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 dbt Core or OpenCTI.

See all dbt Core alternatives → · See all OpenCTI alternatives →

Recent activity from dbt Core and OpenCTI

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

  1. 23h agoOpenCTIWeekly release: data sanity stop, SBOM docs, merge performance
  2. 5d agoOpenCTIWeekly release: integrations experience and draft approval workflow
  3. 13d agoOpenCTIWeekly release: connector catalog becomes a faceted marketplace
  4. 15d agodbt CoreFusion alpha 5: Redshift datasharing catalogs and job-specific deferral
  5. 18d agoOpenCTIWeekly release: live stream, groups and widget fixes
  6. 18d agodbt Coredbt-core 1.12.0 drops `dbt login` and the dbt-state plugin
  7. 19d agoOpenCTIWeekly release: SBOM generation, custom views, ESM frontend
  8. 20d agodbt Core1.12.0 release candidate 3
  9. 25d agodbt Core1.12.0 release candidate 2
  10. 25d agoOpenCTILTS 6: security backports and dependency updates
  11. 28d agodbt Core1.12.0 release candidate 1
  12. 29d agodbt CoreFusion gains read-write Iceberg REST catalogs and catalogs.yml v2

Frequently asked questions

What is the difference between dbt Core and OpenCTI?

They serve adjacent needs but don't currently overlap on shipped themes. dbt Core is currently shipping more aggressively (velocity 7.5 vs 5.0), with 2 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 dbt Core better than OpenCTI?

Sparkpulse doesn't pick a winner — we score release velocity, not feature parity. dbt Core is currently shipping more aggressively (velocity 7.5 vs 5.0), with 2 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 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.

What are the best alternatives to OpenCTI?

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