Install dbt
dbt enables data teams to transform data using analytics engineering best practices. You can run dbt locally through a command line interface (CLI) to build, test, and deploy your data transformations.
dbt Fusion engine (recommended)
For the best local development experience, we recommend the dbt Fusion engine. Built in Rust, Fusion delivers:
- Faster performance — Up to 10x faster parsing, compilation, and execution.
- SQL comprehension — Dialect-aware validation catches errors before they reach your warehouse.
- Column-level lineage — Trace data flow across your entire project.
dbt VS Code extension
The dbt VS Code extension combines Fusion's performance with powerful LSP editor features:
- IntelliSense — Autocomplete for models, macros, and columns.
- Inline errors — See SQL errors as you type.
- Hover insights — View model definitions and column info without leaving your code.
- Refactoring tools — Rename models and columns across your project.
This is the fastest way to get started with dbt locally.
Install Fusion with the dbt VS Code extension
dbt Core
dbt Core is the original Python-based dbt engine. dbt Core changed data transformation forever and includes a rich set of features:
- Apache License 2.0 — dbt Core is open source now and forever.
- Community adapters — An amazing community of contributors has built adapters for a vast catalog of data warehouses.
- Code editor support — Build your dbt project in popular editors like VS Code or Cursor.
- Command line interface — Run your project from the terminal using macOS Terminal, iTerm, or the integrated terminal in your code editor.
Installation
Was this page helpful?
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
0