[Bug]: Consider pointing to the root of the dbt project in target-path using CLI option or env var

[edgarrmondragon]

Package Version

0.1.0

Python Version

NA

Operating System

NA

Description

Starting with dbt 1.7, the dbt clean command fails for directories outside of the project root: dbt-labs/dbt-core#8318.

Perhaps

dbt-ext/files_dbt_ext/bundle/transform/dbt_project.yml

Lines 18 to 24 in e445807

	target-path: ../.meltano/transformers/dbt/target
	log-path: logs
	packages-install-path: dbt_packages
	clean-targets:
	- ../.meltano/transformers/dbt/target
	- dbt_packages
	- logs

should be updated to point to a path in the transform/ directory.

Note

Setting target-path in dbt_project.yml is deprecated in favor of the CLI flag or env var: https://docs.getdbt.com/reference/project-configs/target-path#configuration

Code

No response

[edgarrmondragon]

Shared by a community member in Slack:

fwiw i got things to work by specifying DBT_CLEAN_PROJECT_FILES_ONLY: false in my env (via docker compose file), which lives here

• https://meltano.slack.com/archives/C01TCRBBJD7/p1699395032523659?thread_ts=1699309247.914179&cid=C01TCRBBJD7
• https://www.linen.dev/s/meltano/t/16042194/hi-all-i-m-currently-trying-to-upgrade-my-meltano-managed-db#ae35e269-8ee4-4e72-8e2b-280801d81dc3

[ilsaloving]

This issue has been stale for almost a year, and it really should be addressed. This issue blocks dbt from being used at all, unless the user jumps through hoops to discover the problem and then jury-rigs some mechanism for injecting DBT_CLEAN_PROJECT_FILES_ONLY into the run.

If there are no plans to fix the underlying paths issue, this flag should be enabled by default in the plugin.