[BUG] VSCE "Compile File" button incorrectly displays "Stale File"

[dataders]

The VSCE can successfully compile a project without errors.

However, after compiling, I expected that I could click "Compile File" for a package model, but couldn't even though I could navigate to the compiled file in the target/compiled directory.

I suspect there's some funny business with the package model resource path

model path relative to dbt project
dbt_packages/hubspot/models/staging/tmp/stg_hubspot__contact_tmp.sql

compiled model path
target/compiled/models/staging/tmp/stg_hubspot__contact_tmp.sql

perhaps VSCE is looking for a non-existent path that includes dbt_packages/hubspot/, but that path doesn't exist because all compiled package models are thrown into the same models/ directory?

/*
 * ⚠️ Stale file
 * Compilation completed, but this file was not updated.
 * Try checking the Problems tab or running `dbt compile` in the terminal.
*/

[davidharting]

For a minimal reproduction case I:

• dbtf init a new jaffle shop project
• Install dbt_project_evaluator, which is Fusion compatible and has models.

For the fix I would like to:

• Accurately locate the compiled file
• Put the expected path of the compiled file in the "stale file" comment.

[fa-assistant]

🧹 Stale Issue Detected

This issue has had no meaningful activity for 186 days.

If this is still relevant, please:

• Comment with an update, or
• Add the cleanup/keep label to exempt it from future cleanup scans.

If no action is taken within 30 days, this issue will be scheduled for auto-close with a 7-day grace period.

cc @davidharting — as assignee(s), can you confirm whether this is still active?

---

This notice was posted by the Fusion Issue Cleanup workflow.

[davidharting]

Still a problem today, commenting to prevent auto-close.

[davidharting]

We should have a much better path to fixing this based on this PR: https://github.com/dbt-labs/fs/pull/8590.
Internal slack thread here.