Hi All! What’s the best way to invoke a “profile” when running dbt? When running

--transform

with an

elt

job I get the following error. I’m having trouble debugging this given in my profiles.yml has the profile defined as “meltano” as well as my dbt_project.yml. (screenshots in comments below).

Hi @tom_mcgrail! Can you check if

meltano config dbt list

shows the right path in

profiles_dir

?

Hi @edgar_ramirez_mondragon! Verifying my profiles.yml is located within my profiles_dir.

if the output of

meltano config dbt list

really points to

<meltano_project_root>/transform/profiles

that should rule out a db issue

$ meltano config dbt unset profiles_dir
[2021-10-15 13:32:58,103] [39452|MainThread|dotenv.main] [WARNING] Key DBT_PROFILES_DIR not removed from /Users/edgarramirez/Code/meltano-personal/.env - key doesn't exist.
Transformer 'dbt' setting 'profiles_dir' in the system database was unset

$ meltano config dbt
{
  "project_dir": "/Users/edgarramirez/Code/meltano-personal/transform",
  "profiles_dir": "/Users/edgarramirez/Code/meltano-personal/transform/profile",
  "target": null,
  "source_schema": null,
  "target_schema": "analytics",
  "models": "+"
}

Interesting — thank you for the context here. Below is the output for our dbt config. At this point, I may just scrap our dbt project and start fresh. We had it up and running prior to our system db migration and cant seem to isolate where the issue is.

project_dir [env: DBT_PROJECT_DIR] current value: '/home/ubuntu/meltano-projects/dev/transform' (default: '$MELTANO_PROJECT_ROOT/transform')

profiles_dir [env: DBT_PROFILES_DIR] current value: '/home/ubuntu/meltano-projects/dev/transform/profile' (default: '$MELTANO_PROJECT_ROOT/transform/profile')