// the find
AltimateAI/vscode-dbt-power-user
This extension makes vscode seamlessly work with dbt™: Auto-complete, preview, column lineage, AI docs generation, health checks, cost estimation etc
A VSCode extension for dbt developers that adds autocomplete, column lineage, query preview, AI-assisted doc generation, and a handful of other quality-of-life features. It targets data engineers who live in VSCode and want to avoid context-switching to the dbt Cloud UI or running CLI commands manually.
Column lineage down to the individual column level is genuinely useful and hard to get elsewhere without a paid catalog tool. The defer-to-prod feature brings a dbt Cloud perk to dbt Core users, which is a real gap it fills. Active maintenance — last push two days ago, CI pipeline, dependabot — signals the project isn't abandonware. The breadth of features (preview, health check, SQL validation, BigQuery cost estimation) means you can replace several separate tools with one extension.
The AI features (doc generation, query explanation, model generation) phone home to Altimate's SaaS backend, so you're not just installing an extension — you're signing up for their service, and the docs are vague about what data leaves your environment. The extension description buries this behind 'bring your own LLM' options that require digging through settings to find. At 580 stars it has decent but not massive adoption, which matters for an extension that needs to parse your specific dbt dialect and warehouse correctly — edge cases in Snowflake CTEs or Redshift syntax may surface bugs with slow turnaround. The JavaScript codebase with no obvious TypeScript strict mode and a mix of webview panels means the lineage UI in particular is brittle territory to debug if something breaks.