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

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