Awesome
vscode-dbt-power-user
This open source extension makes VSCode seamlessly work with dbt™.
If you need help with setting up the extension, please check the documentation. For any issues or bugs, please contact us via chat or Slack.
Features:
| Feature | Details |
|---|---|
| Auto-complete dbt™ code | Auto-fill model names, macros, sources and docs. Click on model names, macros, sources to go to definitions. |
| Preview Query results and Analyze | Generate dbt™ model / query results. Export as CSV or analyze results by creating graphs, filters, groups |
| Column lineage | Model lineage as well as column lineage |
| Generate dbt™ Models | from source files or convert SQL to dbt™ Model (docs) |
| Generate documentation | Generate model and column descriptions or write in the UI editor. Save formatted text in YAML files. |
| Defer to prod | Build your model in development without building (by defering) your upstream models |
| Click to run parent / child models and tests | Just click to do common dbt™ operations like running tests, parent / child models or previewing data. |
| Compiled query preview and explanation | Get live preview of compiled query as your write code. Also, generate explanations for dbt™ code written previously (by somebody else) |
| Project health check | Identify issues in your dbt™ project like columns not present, models not materialized |
| SQL validator | Identify issues in SQL like typos in keywords, missing or extra parentheses, non-existent columns |
| Big Query cost estimator | Estimate data that will be processed by dbt™ model in BigQuery |
| Other features | dbt™ logs viewer (force tailing) |
Note: This extension is fully compatible with dev containers, code spaces and remote extension. See Visual Studio Code Remote - Containers and Visual Studio Code Remote - WSL. The extension is supported for dbt™ versions above 1.0.
Features
<a id="autocomplete">Autocomplete model, macro, source names and click to go to definition</a>
Auto-fill model names, macros, sources and docs. Click on model names, macros, sources to go to definitions. (docs)
<a id="querypreview">Preview query results and analyze</a>
Generate dbt™ model / query results. Export as CSV or analyze results by creating graphs, filters, groups. (docs)
<a id="lineage">Column lineage</a>
View model lineage as well as column lineage with components like models, seeds, sources, exposures and info like model types, tests, documentation, linkage types. (docs)
<a id="genmodel"> Generate dbt™ Models from source or SQL</a>
Generate dbt™ models from sources defined in YAML. You can also convert existing SQL to a dbt™ model where references get populated automatically. (docs)
<a id="gendoc"> Generate documentation</a>
Generate model and column descriptions automatically or write descriptions manually in the UI editor. Your descriptions are automatically formatted and saved in YAML files. (docs)
<a id="defertoprod">Defer to prod</a>
Defer building your upstream models when you make changes in development by referencing production models. Here's (more info) about the concept. This functionality can be used in dbt™ core with the extension. (docs)
<a id="clicktorun"> Click to run parent/child models and tests</a>
Just click to do common button operations like executing tests, building or running parent / child models. (docs)
<a id="queryexplanation"> Compiled query preview and explanation</a>
Get live preview of compiled query as your write code. Also, generate explanations for dbt™ code written previously (by somebody else). (docs)
<a id="healthcheck"> Project health check</a>
Identify issues in your dbt™ project like columns not present, models not materialized. (docs)
<a id="validateSQL"> SQL validator</a>
Validate SQL to identify issues like mistyped keywords, extra parentheses, columns no present in database (docs)
<a id="bqcost"> Big Query cost estimator</a>
Estimate data that will be processed by dbt™ model in BigQuery (docs)
<a id="otherfeatures"> Other features</a>
dbt™ logs view (force tailing)
Please check documentation for additional info. For any issues or bugs, please contact us via chat or Slack.