Run results feature not working in dbt 0.19

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

https://www.altimate.ai

MIT License

460 stars 94 forks source link

Run results feature not working in dbt 0.19 #47

Closed ivan-toriya closed 3 years ago

ivan-toriya commented 3 years ago

Using conda enviroment with dbt installation from git.

Constantly "detecting dbt" with no result.

It's working fine with powershell.

What am I doing wrong?

mdesmet commented 3 years ago

what do you mean by "dbt installation from git"? The code is only tested with installation through pip and official dbt releases.

ivan-toriya commented 3 years ago

Installed it from source as in https://docs.getdbt.com/dbt-cli/installation/#install-from-source

I had an error with snowflake plugin when installing from pip.

So I removed dbt-snowflake from requirements cause I don't need it anyway

mdesmet commented 3 years ago

What's the output if you run dbt --version in powershell?

ivan-toriya commented 3 years ago

mdesmet commented 3 years ago

So I'm just guessing here. The plugin offered you to install dbt for you but you selected no?

I see that you activate manually the conda environment, which means that vscode is not aware about your conda environment. This is the pointer, you need to select the correct python environment. See https://code.visualstudio.com/docs/languages/python#_environments

ivan-toriya commented 3 years ago

I've found the problem.

I tried to install with pip again and discovered that some dependencies not compatible with Python 3.9.1 (and when I create new enviroments using conda it's by default instaling 3.9.1) so I downgraded python to 3.8.5 and installed dbt using pip successfully, then changed the interpreter and extension works fine.

ivan-toriya commented 3 years ago

Hmm, sorry for false positive. Seems like a lot of features still not working for me. I'm wondering where's the root of the problems could be, maybe because I'm using conda?

See the compiled SQL and the run status in the statusbar - Not working

See the model graph - Not working

Go to definition - Not working (Tried with CTRL as well)

rudeb0y commented 3 years ago

Same issues

no "go to definition"
the graph is always empty

mdesmet commented 3 years ago

As I'm always running in remote (ubuntu) and sometimes forget all features on windows, I just did some tests using windows but no issues here with current version.

Any errors in the console log (Help -> Toggle Developer tools)?

ivan-toriya commented 3 years ago

Yeah, it has

-1612206308562.log

mdesmet commented 3 years ago

Thanks, that helped, the run results artifacts seems to have slightly changed in the newest dbt version. I will come up with a fix soon. will keep you posted!

mdesmet commented 3 years ago

We have released a new version (0.4.8). For now the run results status won't work in latest version, however it should not impact the other features as model graph or clickthrough. We will need to support different versions of the artifacts.

Let me know if it works.

ivan-toriya commented 3 years ago

My appreciation to you for such a fast fix!

Model graph -- Working Go to definition -- Working Autocompletion -- Working

mdesmet commented 3 years ago

Thanks! If the extension brings you value, please rate or review it on https://marketplace.visualstudio.com/items?itemName=innoverio.vscode-dbt-power-user.