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.

It offers various features across three important phases of dbt and SQL work - develop, test, and collaborate.

Accelerate dbt and SQL Development by 2X

Develop

Test

Collaborate

• Generate dbt model from source or SQL
• Smart-complete code and Click to Run Models
• Query explanation
• Query translation
• Compiled SQL preview and SQL Visualizer

• Preview query results and analysis
• Tests generation
• Column lineage with code visibility
• Defer to prod
• SQL validation without execution

• Collaboration workflows
• Documentation generation
• Project governance in IDE, Git, CI/CD
• SaaS UI for dbt docs and lineage
• Query history and Query bookmarks

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