search

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
469 stars 94 forks source link

Extension can't find projects #1437

Open OneCyrus opened 1 month ago

OneCyrus commented 1 month ago

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?

mdesmet commented 1 month ago

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 commented 1 month ago

@mdesmet i tried to contact you on dbt slack