/vscode-dbt-power-user

This extension makes vscode seamlessly work with dbt.

Primary LanguageTypeScriptMIT LicenseMIT

vscode-dbt-power-user

Last updated Version Installs Build passing

This extension makes vscode seamlessly work with dbt.

Main features:

  • Go to the definition of any models, macro's and sources.
  • Autocompletion of models, macros and sources
  • Ability to run a model through the play button of the document
  • dbt install / update
  • dbt logs viewer (force tailing)

This extension is using the Python extension to detect Python interpreters that are installed in standard locations. See Python Environments.

This extension is fully compatible with the remote extension. See Visual Studio Code Remote - Containers and Visual Studio Code Remote - WSL.

Please let us know about any bugs or feature requests through the github issues.

This extension is sponsored by innover.io.

Features at work

See the model graph

See the graph and execute parent or children models

Go to definition

Go to model definition

Go to macro definition

Go to source definition

Autocompletion

Autocomplete model

Autocomplete macro

Autocomplete source

dbt logs force tailing (new)

dbt logs

Update dbt if dbt is outdated (new)

Update dbt

Install dbt if dbt is not in the Python Environment (new)

Install dbt

How to use the extension

You should associate your .sql files with the jinja-sql language by configuring in Preferences > Settings

Associations

or add the following in settings.json:

    "files.associations": {
        "*.sql": "jinja-sql"
    },