Hi. I wanted to use custom dbt transformations after a sync using my existing dbt project but got an error that the project.yml can’t be found. I realized that Airbyte looks for the models under its original dbt project (normalization). Is it possible to use my existing dbt project instead of normalization project?

Yes, on the dbt command, you can pass the argument

--project-dir=some_directory

and it will use the

dbt_project.yml

from that directory

@[DEPRECATED] Marcos Marx turned this thread into Zendesk ticket 2575 to ensure timely resolution!

@Marcelo Pio de Castro I see that the project-dir is changing according to the workspace-folder/job-id at every sync (/data/xx/x/my-dbt-project-folder). Is there a way to set it dynamically?

It will work with relative paths, so it won't be a problem. I use it the same way

I got it now. Entrypoint.sh does the work. It worked when I only set the argument to my dbt project name. `—project-dir=`m`y-dbt-project-name`

No problem! Ah, unfortunately it won't load dbt-utils, since it does not execute dbt deps. I had to add dbt utils to my git for that to work

you should be able to set up two transforms and have the first one run

dbt deps

, they run in the same dir in the same mounted volume (or at least did when I set it up for the version we run)

Oooooh, nice idea! Thanks a lot!