I'm using

tap-spreadsheets-anywhere

to read jsonl files from S3. So far it looks like it will be successful... however when I try to use environment variables (eg $S3_BUCKET) inside

meltano.yml

it will not work, the env variables are not interpolated. As I have to use the same pipeline across several S3 sources each with at least 20 tables I want to avoid duplicating the same config section over and over. Any ideas?

Hi Ian! It's a known issue unfortunately, but I think https://github.com/meltano/meltano/pull/8268 would fix it.

Thanks (again!) @edgar_ramirez_mondragon this would most definitely solve my problem. What are the chances of this being released in the near future?

It'll most definitely be shipped in the next release. Just need to get some eyes on it before merging.

Good to hear. Thank you!