The dbt Fusion engine and dbt Core v2 are currently in active development. Refer to the following tables to track lifecycle status and feature availability across the available products.
The dbt Fusion engine and dbt Core v2 are in various stages of development depending on deployment type (dbt platform or installed locally). Additionally, the available adapters (data warehouse connectors) are each in various states of their lifecycle. You can track both using the following table:
| Deployment | Adapter | Status |
|---|
| dbt Core v2.0 (local) | | Alpha |
| Fusion (local) | | Preview |
| Snowflake | GA |
| BigQuery | Preview |
| Databricks | Private preview |
| Redshift | Preview |
| Apache Spark (CLI only) | Beta |
| DuckDB (CLI only) | Beta |
| Fusion (dbt platform) | | GA |
| Snowflake | GA |
| BigQuery | Preview |
| Databricks | Private preview |
| Redshift | Preview |
dbt Core v2 and Fusion represent the next evolution of the classic dbt Core toolset, with performance enhancements and powerful new features. dbt Core v2 includes everything available in dbt Core v1.x, plus the speed and power of Fusion. Level up your development by installing the dbt Fusion engine.
To access the full set of features, register with your email address or sign in to your dbt platform account using dbt login. The following table shows which features are available to all users and which require registration:
| Feature | dbt Core v2 (OSS) | Fusion (all users) | Fusion (with registration) |
|---|
Everything in dbt Core today (except dbt docs v1) | ✅ | ✅ | ✅ |
| dbt docs v2 (lite) | ✅ | ✅ | ✅ |
| Syntax error detection | - | ✅ | ✅ |
| LSP (lite) | - | ✅ | ✅ |
| SQL Comprehension | - | - | ✅ |
| Full LSP | - | - | ✅ |
| Query cache | - | - | ✅ |
| dbt docs v2 (full) | - | - | ✅ |
| dbt State | - | - | ✅ |
| dbt Mesh | - | - | ✅ |
| Auto-deferral | - | - | ✅ |
| Compare changes | - | - | ✅ |
| Precise column-level lineage artifact generation | - | - | ✅ |
dbt lineage command | - | - | ✅ |
The dbt VS Code extension gives you a powerful set of features to level up your local development workflows. To access the full set, register with your email address or sign in with your dbt platform account. The following table shows which features are available to all users and which require registration:
| Feature | Available to all | Available to registered users |
|---|
| Error diagnostics for Jinja, YAML, and SQL syntax errors | ✅ | ✅ |
| Jinja LSP go-to ref definition | ✅ | ✅ |
| Jinja LSP go-to source definition | ✅ | ✅ |
| Jinja LSP go-to macro definition | ✅ | ✅ |
| Diagnostics for linter warnings | ✅ | ✅ |
| Table-level lineage visualization | ✅ | ✅ |
Basic dbt command UI (Run, Build, Test + Query Results Tab) | ✅ | ✅ |
| Ref autocomplete | ✅ | ✅ |
| Autorefactor ref names | ✅ | ✅ |
| Autorefactor column names on change | ✅ | ✅ |
| Dialect-aware function autocomplete | ✅ | ✅ |
| Error diagnostics for SQL types, schema errors, and more | - | ✅ |
| Preview CTE | - | ✅ |
| Query cache for faster incremental compiles | - | ✅ |
| Model docs tab with platform metadata hydration | - | ✅ |
| Column-level lineage visualization | - | ✅ |
| Compare changes | - | ✅ |
| SQL LSP go-to Column definition | - | ✅ |
| SQL LSP go-to CTE definition | - | ✅ |
| SQL LSP hover to see schema for select * | - | ✅ |
dbt Fusion engine powers dbt development everywhere, including the dbt platform, VS Code/Cursor/Windsurf, and locally.
Check out the following table to see what development solutions are available and where you can use them:
| Features you can use | Who can use it? | Solutions available |
|---|
dbt platform with Fusion or dbt Core engine | - Canvas - Insights - Studio IDE - dbt CLI - dbt VS Code extension (VS Code/ Cursor/ Windsurf. Fusion only.) | - dbt platform licensed users - Anyone getting started with dbt
| - dbt Fusion engine: Rust-based engine that delivers fast, reliable compilation, analysis, validation, state awareness, and job execution with visual LSP features like autocomplete, inline errors, live previews, and lineage, and more.
- dbt Core: Uses the Python-based dbt Core engine for traditional workflows. Does not include LSP features. |
| Self-hosted Fusion | - dbt VS Code extension (VS Code/Cursor/Windsurf) - Fusion CLI | - dbt platform users - dbt Fusion users - Anyone getting started with dbt | - VS Code extension: Combines dbt Fusion engine performance with visual LSP features when developing locally.
- Fusion CLI: Provides Fusion performance benefits (faster parsing, compilation, execution) but does not include LSP features. |
| Self-hosted dbt Core v1 | - dbt Core v1 CLI | - dbt Core users - Anyone getting started with dbt | Uses the Python-based dbt Core engine for traditional workflows. Does not include LSP features.
To use the Fusion features locally, install the VS Code extension or Fusion CLI. |
| Self-hosted dbt Core v2 | Coming soon | - Currently in Alpha | Uses the Rust-based dbt Fusion engine. |