Welcome

dbt Power User extension is developed to acccelerate dbt and SQL development in VSCode. It's an open source extension (code repo), and it's listed on the VSCode Marketplace.

Features

The extension offers many features that can accelerate your work:

• Generate models from your source definitions or SQL
• Query result set visualization and export
• Compiled query preview and explanation
• Update dbt Model or SQL using natural language
• Model and column lineage of dbt models
• Autocompletion of models, macros, sources and docs code
• Defer to prod in IDE
• Build / run upstream and downstream models n tests
• Go to the definition of any models, macros, sources and docs
• Generate and write documentation in UI
• Generate and edit tests
• dbt project governance and SQL validator
• Collaborate on code and documentation via VSCode and UI
• Translate SQL queries in different dialects
• Big Query cost estimator
• Utilities - dbt logs viewer (force tailing)

Support

It is developed and mainted by Altimate AI team. Please join the dbt Community Slack Channel #tools-dbt-power-user to meet with the community of users of the extension.

If you run into issues, please contact us via Slack or chat.