Skip to content
| Marketplace
Sign in
Visual Studio Code>Programming Languages>Holidu DBT ForkNew to Visual Studio Code? Get it now.
Holidu DBT Fork

Holidu DBT Fork

Holidu Gmbh

|
2,085 installs
| (2) | Free
This extension makes vscode seamlessly work with dbt: auto-complete, preview, column lineage, AI docs generation, health checks, cost estimation etc
Installation
Launch VS Code Quick Open (Ctrl+P), paste the following command, and press enter.
Copied to clipboard
More Info

Fork to add aws-vault support for Athena & Redshift DBT use cases

New configuration to specifiy aws-vault command line call to authenticate credentials

Follow the steps in .github/workflows/ci.yml to install node dependencies

Run npm run build-vsix to build the extension

vscode-dbt-power-user

Last updated Version Installs Build passing

This open source extension makes VSCode seamlessly work with dbt.

If you need help with setting up the extension, please check the documentation. For any issues or bugs, please contact us via chat or Slack.

Features:

Feature Details
Auto-complete dbt code Auto-fill model names, macros, sources and docs. Click on model names, macros, sources to go to definitions.
Preview Query results and Analyze Generate dbt model / query results. Export as CSV or analyze results by creating graphs, filters, groups
Column lineage Model lineage as well as column lineage
Generate dbt Models from source files or convert SQL to dbt Model (docs)
Generate documentation Generate model and column descriptions or write in the UI editor. Save formatted text in YAML files.
Click to run parent / child models and tests Just click to do common dbt operations like running tests, parent / child models or previewing data.
Compiled query preview and explanation Get live preview of compiled query as your write code. Also, generate explanations for dbt code written previously (by somebody else)
Project health check Identify issues in your dbt project like columns not present, models not materialized
SQL validator Identify issues in SQL like typos in keywords, missing or extra parentheses, non-existent columns
Big Query cost estimator Estimate data that will be processed by dbt model in BigQuery
Other features dbt logs viewer (force tailing)

Note: This extension is fully compatible with dev containers, code spaces and remote extension. See Visual Studio Code Remote - Containers and Visual Studio Code Remote - WSL. The extension is supported for dbt versions above 1.0.

Features

Autocomplete model, macro, source names and click to go to definition

Auto-fill model names, macros, sources and docs. Click on model names, macros, sources to go to definitions. (docs)

autocomplete

Preview query results and analyze

Generate dbt model / query results. Export as CSV or analyze results by creating graphs, filters, groups. (docs)

previewquery

Column lineage

View model lineage as well as column lineage with components like models, seeds, sources, exposures and info like model types, tests, documentation, linkage types. (docs)

lineage

Generate dbt Models from source or SQL

Generate dbt models from sources defined in YAML. You can also convert existing SQL to a dbt model where references get populated automatically. (docs)

genmodel

Generate documentation

Generate model and column descriptions automatically or write descriptions manually in the UI editor. Your descriptions are automatically formatted and saved in YAML files. (docs)

gendoc

Click to run parent/child models and tests

Just click to do common button operations like executing tests, building or running parent / child models. (docs)

autocomplete

Compiled query preview and explanation

Get live preview of compiled query as your write code. Also, generate explanations for dbt code written previously (by somebody else). (docs)

explanation

Project health check

Identify issues in your dbt project like columns not present, models not materialized. (docs)

healthcheck

SQL validator

Validate SQL to identify issues like mistyped keywords, extra parentheses, columns no present in database (docs)

sql-validator

Big Query cost estimator

Estimate data that will be processed by dbt model in BigQuery (docs)

bqcostestimator

Other features

dbt logs view (force tailing)

dbt-log

Please check documentation for additional info. For any issues or bugs, please contact us via chat or Slack.

  • Contact us
  • Jobs
  • Privacy
  • Manage cookies
  • Terms of use
  • Trademarks
© 2025 Microsoft