Extension can't find projects

[OneCyrus]

Expected behavior

Load dbt projects as it did before. v0.44.5 works as expected. But after that it is broken.

Actual behavior

can't find any projects anymore:

2024-09-27 08:48:47.357 [info] discoverProjects:foundProjects [[]]
2024-09-27 08:48:47.358 [info] discoverProjects:allowListFolders [[]]
2024-09-27 08:48:47.358 [info] discoverProjects:foundProjectsAfterFilter [[]]
2024-09-27 08:48:50.214 [info] discoverProjects:foundProjectsAfterProjectIntegrationFilter [[]]

Steps To Reproduce

just opening vscode with your extension

Log output/Screenshots

before it looked like this:

2024-09-27 08:47:07.923 [info] discoverProjects:foundProjects [[{"$mid":1,"fsPath":"/workspaces/automation-data/.venv/lib64/python3.11/site-packages/dbt/include/duckdb/dbt_project.yml","path":"/workspaces/automation-data/.venv/lib64/python3.11/site-packages/dbt/include/duckdb/dbt_project.yml","scheme":"file"},{"$mid":1,"fsPath":"/workspaces/automation-data/.venv/lib64/python3.11/site-packages/dbt/include/starter_project/dbt_project.yml","path":"/workspaces/automation-data/.venv/lib64/python3.11/site-packages/dbt/include/starter_project/dbt_project.yml","scheme":"file"},{"$mid":1,"fsPath":"/workspaces/automation-data/.venv/lib64/python3.11/site-packages/dbt/include/global_project/dbt_project.yml","path":"/workspaces/automation-data/.venv/lib64/python3.11/site-packages/dbt/include/global_project/dbt_project.yml","scheme":"file"},{"$mid":1,"fsPath":"/workspaces/automation-data/cmdbexport/infrastructure/dbt_project.yml","path":"/workspaces/automation-data/cmdbexport/infrastructure/dbt_project.yml","scheme":"file"},{"$mid":1,"fsPath":"/workspaces/automation-data/.venv/lib/python3.11/site-packages/dbt/include/duckdb/dbt_project.yml","path":"/workspaces/automation-data/.venv/lib/python3.11/site-packages/dbt/include/duckdb/dbt_project.yml","scheme":"file"},{"$mid":1,"fsPath":"/workspaces/automation-data/.venv/lib/python3.11/site-packages/dbt/include/starter_project/dbt_project.yml","path":"/workspaces/automation-data/.venv/lib/python3.11/site-packages/dbt/include/starter_project/dbt_project.yml","scheme":"file"},{"$mid":1,"fsPath":"/workspaces/automation-data/.venv/lib/python3.11/site-packages/dbt/include/global_project/dbt_project.yml","path":"/workspaces/automation-data/.venv/lib/python3.11/site-packages/dbt/include/global_project/dbt_project.yml","scheme":"file"},{"$mid":1,"fsPath":"/workspaces/automation-data/cmdbexport/workplace/dbt_project.yml","path":"/workspaces/automation-data/cmdbexport/workplace/dbt_project.yml","scheme":"file"},{"$mid":1,"fsPath":"/workspaces/automation-data/cmdbexport/usm/dbt_project.yml","path":"/workspaces/automation-data/cmdbexport/usm/dbt_project.yml","scheme":"file"}]]
2024-09-27 08:47:07.924 [info] discoverProjects:allowListFolders [[]]
2024-09-27 08:47:07.924 [info] discoverProjects:foundProjectInVenv ["/workspaces/automation-data/.venv/lib64/python3.11/site-packages/dbt/include/duckdb/dbt_project.yml"]
2024-09-27 08:47:07.924 [info] discoverProjects:foundProjectInVenv ["/workspaces/automation-data/.venv/lib64/python3.11/site-packages/dbt/include/starter_project/dbt_project.yml"]
2024-09-27 08:47:07.924 [info] discoverProjects:foundProjectInVenv ["/workspaces/automation-data/.venv/lib64/python3.11/site-packages/dbt/include/global_project/dbt_project.yml"]
2024-09-27 08:47:07.924 [info] discoverProjects:foundProjectInVenv ["/workspaces/automation-data/.venv/lib/python3.11/site-packages/dbt/include/duckdb/dbt_project.yml"]
2024-09-27 08:47:07.924 [info] discoverProjects:foundProjectInVenv ["/workspaces/automation-data/.venv/lib/python3.11/site-packages/dbt/include/starter_project/dbt_project.yml"]
2024-09-27 08:47:07.924 [info] discoverProjects:foundProjectInVenv ["/workspaces/automation-data/.venv/lib/python3.11/site-packages/dbt/include/global_project/dbt_project.yml"]
2024-09-27 08:47:07.924 [info] discoverProjects:foundProjectsAfterFilter [[{"$mid":1,"fsPath":"/workspaces/automation-data/cmdbexport/infrastructure","path":"/workspaces/automation-data/cmdbexport/infrastructure","scheme":"file"},{"$mid":1,"fsPath":"/workspaces/automation-data/cmdbexport/workplace","path":"/workspaces/automation-data/cmdbexport/workplace","scheme":"file"},{"$mid":1,"fsPath":"/workspaces/automation-data/cmdbexport/usm","path":"/workspaces/automation-data/cmdbexport/usm","scheme":"file"}]]
2024-09-27 08:47:11.635 [info] discoverProjects:foundProjectsAfterProjectIntegrationFilter [[{"$mid":1,"fsPath":"/workspaces/automation-data/cmdbexport/infrastructure","external":"file:///workspaces/automation-data/cmdbexport/infrastructure","path":"/workspaces/automation-data/cmdbexport/infrastructure","scheme":"file"},{"$mid":1,"fsPath":"/workspaces/automation-data/cmdbexport/workplace","external":"file:///workspaces/automation-data/cmdbexport/workplace","path":"/workspaces/automation-data/cmdbexport/workplace","scheme":"file"},{"$mid":1,"fsPath":"/workspaces/automation-data/cmdbexport/usm","external":"file:///workspaces/automation-data/cmdbexport/usm","path":"/workspaces/automation-data/cmdbexport/usm","scheme":"file"}]]

Operating System

Ubuntu 22.04

dbt version

1.8

dbt Adapter

duckdb

dbt Power User version

0.45.3

Are you willing to submit PR?

• Yes I am willing to submit a PR!

[mdesmet]

I had a look at the code changes since 0.44.5 but we haven't changed anything related to project detection. Could you provide full log details? You can contact me on dbt slack.

[OneCyrus]

@mdesmet i tried to contact you on dbt slack

[OneCyrus]

@mdesmet this is still broken. can we have an extension setting to list all the projects so we don't need to rely on autodiscovery of projects?