Consider changes related to native DBT_PROJECT_DIR support in dbt-core

[aaronsteers]

Follows from:

• add env DBT_PROJECT_DIR support #6078 dbt-labs/dbt-core#6659 (merged but not released, as of March 9, 2023)

I don't know if any changes are needed, especially because we want to be mindful of preserving backwards compatibility.

As of now, we have:

https://github.com/meltano/hub/blob/main/_data/meltano/utilities/dbt-snowflake/dbt-labs.yml#L86-L88

settings:
// ...
- label: Projects Directory
  name: project_dir
  value: $MELTANO_PROJECT_ROOT/transform

This almost maps to DBT_PROJECT_DIR except that the name of the plugin is dbt-snowflake (or similar), so the mapped env var would be something like DBT_SNOWFLAKE_PROJECT_DIR.

[aaronsteers]

Correction: our source code does already use this env var (same name).

dbt-ext/dbt_ext/extension.py

Lines 43 to 46 in a53bf00

	self.dbt_project_dir = Path(os.getenv("DBT_PROJECT_DIR", "transform"))
	self.dbt_profiles_dir = Path(
	os.getenv("DBT_PROFILES_DIR", self.dbt_project_dir / "profiles")
	)

And this Hub-side PR merging today will ensure it gets mapped from the related setting names:

• fix: unmapped DBT_PROJECT_DIR env vars for dbt setting hub#1156

[aaronsteers]

@tayloramurphy and @pnadolny13 - I don't think there's anything for us to do here, but just wanted to call it out in case you see something I don't see.

As of the next dbt-core release, DBT_PROJECT_DIR will be parsed natively, meaning for those versions of dbt that support it, we will no longer need to cd into the directory or pass --project_dir.