[CT-2439] [Bug] dbt source freshness'output(_dir) not using target-path specified in dbt_project.yml

[ChenyuLInx]

Is this a new bug in dbt-core?

• I believe this is a new bug in dbt-core
• I have searched the existing issues, and I could not find an existing issue for this bug

Current Behavior

dbt source freshness will write sources.json to default running dir instead of respecting the target-dir specified in dbt_project.yml.

Expected Behavior

When a target-path is specified in dbt_project.yml, dbt-core would write sources.json to that path.

Steps To Reproduce

Specify a target-path in dbt_project.yml that's different from default path. Run source freshness. You will see sources.json being written to the target dir in the current path not the path specified in dbt_project.yml

[jtcohen6]

Should --target-path graduate to being a top-level / "global" config? i.e.

$ dbt --target-path source freshness

[ChenyuLInx]

@jtcohen6 Good question, I didn't touch --target-path in my change, all I did was to make sources.json write to target-path specified in dbt_project.yml.
source freshness doesn't support --target-path CLI arg since 1.4 at least. There's currently a community issue and PR regarding it. It is merged to main but TBD on whether this should be backported.