I’m having trouble using environment variables to configure a loader.

loaders:
  - name: target-snowflake
    pip_url: pipelinewise-target-snowflake==1.12.0
    capabilities:
    - catalog
    - discover
    - state
    config:
      file_format: FILE_FORMATS.CSV
      user: MY_USER
      role: MY_ROLE
      default_target_schema: MY_SCHEMA

In my

.env

I have

TARGET_SNOWFLAKE_DBNAME="MELTANO"

. When I run an

elt

I get a configuration error complaining that it’s not set:

$  meltano --log-level=info elt --job_id=wip tap-postgres target-snowflake
...
target-snowflake |    * Required key is missing from config: [dbname]
meltano          | Loading failed (1):    * Required key is missing from config: [dbname]

I think I’m using the expected variable name according to the docs: https://github.com/transferwise/pipelinewise-target-snowflake#to-run-tests

Did you make sure to

source .env

before you ran the command?

Doesn’t help unfortunately

@dean_morin Can you add

variant: transferwise

to the definition?

Let me give that a try…

@dean_morin The only thing to be aware of is that Meltano won't look for settings in env vars until it knows the setting exists: https://meltano.slack.com/archives/CFG3C3C66/p1615304264116800?thread_ts=1615297554.110300&cid=CFG3C3C66

That worked, thanks for the help!