Are these instructions regarding dbt-postgres stil...
# troubleshooting
w
Are these instructions regarding dbt-postgres still valid? https://docs.meltano.com/getting-started/#transform-loaded-data-for-analysis I am trying to setup our meltano project on a new dev machine and am having issues with pytz. Tried removing dbt-postgres and reinstalling it and getting a message about "Installing 0 plugins...". At one point also had an error where it was asking for DBT_POSTGRES_HOST when it should be using the meltano env variables. Any help any pointing me the right direction is much appreciated.
I was finally able to get it by updating meltano.yml and entering versions 1.5 for dbt and dbt-postgres prior to running
meltano install transformer dbt-postgres
and then adding the second set of environmental variables for DBT_POSTGRES_... It does seem like sharing config files across developers and production is an issue. Curious if people are using dbt stand alone to get around some of these issues.
u
@will_johnson we've migrated to recommending the dbt
utilities
over dbt
transformer
that doc you referenced should be updated (I'll create an issue for it) but you can follow https://docs.meltano.com/guide/transformation or https://docs.meltano.com/getting-started/part3
u
The TLDR is previously with the transformer type all of the integration logic was inside meltano core which had some disadvantages like a slow iteration cycle, making alterations to the logic for custom use cases was hard, etc. Now with utilities the logic lives outside the meltano core repo (dbt-ext) and is installed/called as a standalone package similar to how the rest of meltano's plugin architecture works.