Meltano

image.png

I understand how to fix this, but it's the horrible part of my experiance with dbt and meltano

meltano.yml incoming

password is for dev not a big deal to me

```  loaders:
  - name: target-postgres
    variant: transferwise
    pip_url: pipelinewise-target-postgres psycopg2-binary psycopg2
    config:
      host: localhost
      port: 5432
      user: postgres
      dbname: postgres
      password: cb7cd89dc59e4da7b249e4f8f7c929d6
  transformers:
  - name: dbt
    pip_url: dbt==0.21.1
    config:
      target: postgres
  files:
  - name: dbt
    pip_url: git+<https://gitlab.com/meltano/files-dbt.git@config-version-2>```
This is following the default "meltano optimized" loader and configuration available (Works with `meltano run tap-name target-postgres` ) but when dbt is installed following all the docs, it still doesn't work

"horrible" is a steep word but it's the brief feeling I have when hitting this every time I set it up and forget how to fix it

Forgot the error is triggered when running `meltano invoke dbt:run`  <https://docs.meltano.com/guide/transformation#:~:text=your%20pipeline%20using-,invoke%20dbt%3Arun,->.

<@U06CCB0EUBC> yeah that sounds annoying, It looks like the file bundle profile is expecting you to have run dbt using `meltano elt`  because no postgres environment variables would be set automatically otherwise. In the <https://docs.meltano.com/getting-started#transform-loaded-data-for-analysis|transform section> of the getting started guide I changed it to use `invoke` and it has details for setting up environment configurations for it to work. Also check out <https://docs.meltano.com/guide/transformation#transform-in-your-elt-pipeline|this section> for how I tried to describe the two different ways of executing dbt

Feedback on how to improve the dbt integration and also how to direct people to the right documentation (assuming these docs answer at least some of your questions) would be helpful too! :smile: