https://linen.dev logo
#plugins-general
Title
# plugins-general
a

Andy Carter

05/24/2023, 1:12 PM
I think I've come across the 'using env vars in an array' issue (https://github.com/meltano/meltano/issues/3171) and looking for an alternative solution One thing I've seen suggested is to hard code the value for
{DYNAMICS_PATH}
in
meltano.yml
but then use the
environment
key to toggle between them. I'm fine with that, but is there any way to do that that doesn't require duplicating the
field_names
array in both environments? I have some large spreadsheets with hundreds of columns and would really rather avoid duplicating the list in both
prod
and
dev
envs
Copy code
plugins:
  extractors:  
  - name: tap-spreadsheets-anywhere
    variant: ets
    pip_url: git+<https://github.com/ets/tap-spreadsheets-anywhere.git>
    config:
      tables:
      - path: azure://${DYNAMICS_PATH}
        field_names: 
          - Id
          - SinkCreatedOn
          - 498 other fields