Hello, I'm just getting going with Meltano and DBT...
# plugins-dbtr
Randall Rodakowski
06/19/2025, 3:00 AMHello, I'm just getting going with Meltano and DBT. I can't figure out why meltano is trying to look for the profiles.yml in the wrong place. I am getting this error: Error: Invalid value for '--profiles-dir': Path '{path_to_my_project}/transform/profile'. I can see the meltano profiles.yml file in this path: {path_to_my_project|/transform/profiles/postgres/profiles.yml . I am not setting profiles_dir anywhere in my meltano.yml file.
✅ 1
e
Edgar Ramírez (Arch.dev)
06/19/2025, 3:39 PMCan you try removing the dbt
transformerdbt-postgresr
Randall Rodakowski
06/19/2025, 6:00 PMok am trying, if I follow you, there's no dbt-postgres transformer defined in the meltano.yml project file, which makes uncertain about what to declare in the file versus using the cli to add things
Randall Rodakowski
06/20/2025, 1:12 AMOk, I tried the dbt-postgres utility. I got further but am not getting the following error:
Randall Rodakowski
06/20/2025, 1:14 AMWhat's strange is that dbt_project.yml is generated with a path to .meltano/transformers/dbt/target that does not exist. After using the dbt-postgres utility, the path in my project is .meltano/utilities/dbt-postgres
Randall Rodakowski
06/20/2025, 1:15 AMand thanks @Edgar Ramírez (Arch.dev) for your advice to switch to the utility
Randall Rodakowski
06/23/2025, 7:43 PMFYI, I was able to get past this by manually editing the dbt_project.yml file that was generated by meltano and remove the incorrect paths. I will commit that file into my project and not relay on that being generated I suppose.
👍 2
10 Views