Skip to content
| Marketplace
Sign in
Visual Studio Code>Other>dbt Databricks Power UserNew to Visual Studio Code? Get it now.
dbt Databricks Power User

dbt Databricks Power User

mobiusww

|
6,342 installs
| (1) | Free
This extension makes vscode work with dbt and Databricks (and other data platforms like BigQuery)
Installation
Launch VS Code Quick Open (Ctrl+P), paste the following command, and press enter.
Copied to clipboard
More Info

vscode-dbt-databricks-power-user

This extension makes vscode work with dbt and Databricks (It should also work with other data platforms like BiqQuery, but I haven't got chance to test other platforms, so let me know how you go if you have tried :) ) This extension is a fork on the vscode-dbt-power-user extension made by Innoverio, and the vscode-dbt-bigquery-power-user made by Butchland.

In addition to the existing functions (e.g. Compile Current Model Compile Current Model, Run Current Model Run Current Model, and more) of the vscode-dbt-power-user, the following seven functions have been added via the buttons on the active windows (See below for the added functions/buttons).

  • Preview Current Model List models - runs 'dbt list' to lists resources in your dbt project. It updates the model nodes tree when your update your model. A dbt.listModelsDisabled flag can be set in the extension setup to enable/disable automatic listing of models when files change. If auto-list is disabled (which I personally prefer), this button here can be handy.
  • Preview Current Model Preview Current Model - uses the compiled SQL to preview the table without materializing it on the cloud. Note: this operation triggers a DBT re-compiling first. If you don't need to recompile, you can user 'Show Compiled' and 'Run SQL As-is'
  • Show Compiled Show Compiled - opens the compiled sql version of the model (inherited from Butchland's work)
  • Run SQL As-is Run SQL As-Is - runs the 'as-is' (i.e. even the unsaved code) SQL from current active window. For example, it can be used on the compiled code or be used like a query editor, but very likely it won't work on the model window as it doesn't compile codes like '{{ ref('example_model') }}'.
  • Get Current Model from Cloud Get Current Model from Cloud - fetches the data from the materialized table/view from the cloud using 'SELECT * FROM example_model_table LIMIT 25' query
  • Generate DBT Docs Generate DBT Docs - generates the DBT documents
  • View DBT Docs View DBT Docs - serves and allows viewing the generated DBT documents in a web browser.

Preview SQL example

The vscode-dbt-databricks-power-user extension is a drop-in replacement for vscode-dbt-power-user and uses the same config.

Troubleshoot when the buttons are not shown

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"
    },
  • Contact us
  • Jobs
  • Privacy
  • Manage cookies
  • Terms of use
  • Trademarks
© 2025 Microsoft