DBT project not loading

[Will-Cottrell]

Expected behavior

I can use Power User for dbt features in VS Code

Actual behavior

Error messages are shown when trying to use features such as Query Results, Compile and Lineage.

Steps To Reproduce

Power User has recently been working but after reinstalling a virtual environment and updating requirements it has stopped working.

Log output/Screenshots

Operating System

Mac OS 14.5 (23F79)

dbt version

core 1.8.5

dbt Adapter

bigquery 1.8.2

dbt Power User version

v0.44.0

Are you willing to submit PR?

• Yes I am willing to submit a PR!

[kalebkemp]

I'm having the same issue ☹️
with dbt-core 1.8.5
dbt-databricks 1.8.5
power user version v0.44.1
Windows 11

Edit to add: It was working yesterday before updating VSCode (not sure if it's related). Have tried uninstalling/reinstalling the extension, initializing a new dbt project, restarts, etc.

edit again to add: I also re-created a virtual environment after deleting my local folder and grabbing latest from my main branch in github

[anandgupta42]

@kalebkemp, could you downgrade to version 0.42.X and check if it resolves the issue? Also, both of you are on dbt 1.8.5, which might be causing the problem.

[mdesmet]

This error seems related to vscode's Python extension. What happens if you restart vscode, does this error go away?

[Will-Cottrell]

Restarted VSCode and reverted power user to v0.42.7 but the issue persists. I fear it is something to do with dbt 1.8.5

[kalebkemp]

Mine actually seemingly randomly started working again... I'm not sure what was the exact solution, I did not downgrade. I had restarted vscode, my pc, uninstalled and reinstalled extensions to no avail, but it seemed like after making various changes in my code and pushing/pulling from github it started working... Sorry I can't provide an exact answer on what fixed this..

As a side question: What version of dbt-core would you recommend? Is there some issue with 1.8.5?

[anandgupta42]

This may be related to this issue in the Python extension. The fix was released 3 days ago, and perhaps that's why your environment started working, @kalebkemp. @Will-Cottrell, is this still an issue for you?

[Will-Cottrell]

Unfortunately it hasn't fixed it for me, still cannot use Power User

[c-l-nguyen-blacklane]

Same for me. I am on Snowflake but the error is the same

[anandgupta42]

realted to #1334

[thebroberts]

this should be fixed now:
7c26b35
#1379

[Will-Cottrell]

Have checked this morning and I still cannot load a dbt project 😢

[anandgupta42]

@Will-Cottrell What's the version of extension installed on your machine?

[anandgupta42]

@Will-Cottrell @c-l-nguyen-blacklane we haven't been able to identify the root cause of this issue. Since the extension isn't loading, we're unable to generate the diagnostics or logs that typically help us resolve the problems. Can one of you ping reach out here : https://app.myaltimate.com/contactus ?

[anandgupta42]

this is duplicate of #1334

[Will-Cottrell]

Completely uninstalling VSCode, removing files and settings and reinstalling has fixed the issue.