vscode-dbt-power-user

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

Go to definition

Autocompletion

dbt logs force tailing (new)

Update dbt if dbt is outdated (new)

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

How to use the extension

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

or add the following in settings.json:

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