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
452 stars 86 forks source link

Lineage tab doesn't show any info #1350

Closed RicardoVilaca closed 1 month ago

RicardoVilaca commented 1 month ago

Expected behavior

When i first downloaded my dbt project, the lineage tab was working fine. But after a few days it shows nothing.

Actual behavior

Even though having a clean and compiled project, the lineage stopped working.

Steps To Reproduce

Honestly, i don't know how to reproduce it.

Log output/Screenshots

image

Operating System

Windows

dbt version

dbt Cloud CLI - 0.38.7

dbt Adapter

Snowflake

dbt Power User version

0.43.3

Are you willing to submit PR?

anandgupta42 commented 1 month ago

@RicardoVilaca, have you chosen a .sql file in the code editor? It's not clear in the screenshot

RicardoVilaca commented 1 month ago

Yes yes, i chose a valid sql file.

image

I can also see that the lineage shows correctly on the dbt web editor (same branch, everything up to date).

I ran "dbt compile" as well and everything went smoothly. The project seems to have no issues but the extension can't fetch the lineage.

The problem occurs in both legacy and the new UI.

Also tried the reset button ofc, which is not responding.

anandgupta42 commented 1 month ago

@RicardoVilaca Can you please ping us from the chatbot located in the lower right corner after logging into your SaaS instance? We need more information to debug the issue.

RicardoVilaca commented 1 month ago

Sorry, but currently i'm not using the Team version :(

We just tested this extension this week for the first time.

RicardoVilaca commented 1 month ago

I also noticed this issue

image

anandgupta42 commented 1 month ago

@RicardoVilaca, we have implemented a fix to address the file path issue. However, we cannot guarantee that this will resolve the original problem of the lineage not displaying. We have included additional logging to aid in identifying the root cause. Please upgrade to the latest version 0.43.4 and let us know

RicardoVilaca commented 1 month ago

Hey @anandgupta42 , this fixed the "ENOENT" issue, but it still didn't fix the lineage problem.

Also i noticed that the datapilot doesn't consider the models as valid

image

Although i'm pretty sure that every model is valid because "dbt run" goes without issues until the end

RicardoVilaca commented 1 month ago

This issue was fixed today. I can see my lineage again. Not sure if it was the last patch, or if it was something on my project that changed though..

anandgupta42 commented 1 month ago

@RicardoVilaca It was because of the last patch. I am glad lineage is working for you now.