vscode-dbt-power-user

vscode-dbt-power-user copied to clipboard

Expected behavior

Vscode default substitute variables e.g. ${workspaceFolder} doesn't work for runModelCommandAdditionalParams and buildModelCommandAdditionalParams. In my workflow, I use dbt deferred mode. Ideally, my settings.json would look like: e.g.

"dbt.runModelCommandAdditionalParams": [
    "--state",  
    "${workspaceFolder}/path/to/state", 
    "--defer", 
  ]

And a task would be launched

> Executing task: dbt run --select <model> --state /path/to/work/space/path/to/state --defer

Actual behavior

path variable ${workspaceFolder} was not correctly substituted with the right path to workspace

> Executing task: dbt run --select <model> --state ${workspaceFolder}/path/to/state --defer

Steps To Reproduce

1. Add the following code block to your settings.json

"dbt.runModelCommandAdditionalParams": [
    "--state",  
    "${workspaceFolder}/path/to/state", 
    "--defer", 
  ]

2. navigate to any of your model files
3. click the database dbt run button
4. observe commands executed in terminal

Log output/Screenshots

No response

Operating System

Mac OS

dbt version

1.3.4

dbt Adapter

Bigquery

dbt Power User version

v0.13.0

Are you willing to submit PR?

• [ ] Yes I am willing to submit a PR!