Reuben

I would like to add an end-to-end test for `--state-id-suffix` in [`test_run.py`](https://github.com/meltano/meltano/blob/fba29109eb36cde61d652e17960a241ed5d8edca/tests/meltano/cli/test_run.py) to check a state ID is generated with the given suffix, but the existing tests are quite complex...

Unrelated test failure: https://github.com/meltano/meltano/actions/runs/3087082213/jobs/4992077395#step:11:3279

@pandemicsyn I've resolved all conversations I think are complete, just waiting on the others.

Clarification on current support for environment variable interpolation within `meltano.yml` [here](https://meltano.slack.com/archives/C01TCRBBJD7/p1663866176283339?thread_ts=1663720682.059949&cid=C01TCRBBJD7) from @kgpayne. > all values read via the MeltanoYmlStoreManager are marked as expandable My question is that if this...

+1 on this. At the moment, we are creating a temporary environment per (our concept of a) pipeline as a workaround. ```sh MELTANO_ENVIRONMENT=$PIPELINE_ID meltano add environment "$MELTANO_ENVIRONMENT" export MELTANO_ENVIRONMENT meltano...

I have an implementation for this working locally, but I'm away on holiday for 2 weeks now so I'll open a PR when I'm back. Until then, a few things:...

@pandemicsyn Like the idea of `:` as a common segement delimiter, although there would have to be enforcement of a limited character-set for the prefix value. Don't see why a...

@aaronsteers Yes, that is basically our requirement. This issue and #6164 sound very similar to me (even so far as mentioning `:` delimiting and the concept of a suffix in...

[PurePath.match](https://docs.python.org/3/library/pathlib.html#pathlib.PurePath.match) behaves a little differently to [Path.glob](https://docs.python.org/3/library/pathlib.html#pathlib.Path.glob), and so doesn't currently support `**` (this directory and all subdirectories, recursively). See: - https://stackoverflow.com/questions/67827443/python-pathlib-match-function-doesnt-work - https://discuss.python.org/t/pathlib-path-match-and/9052 - https://bugs.python.org/issue29249

I am also interested in this. :+1: What else needs doing to get it merged?