Hello everyone, I'm trying to launch Meltano like this :

RUN meltano config tap-postgres set _metadata 'public-metric_value' replication-key date_modified

It works perfectly, but the thing is that

date_modified

is not the only column I should check. Basically, I would like to run this :

RUN meltano config tap-postgres set _metadata 'public-metric_value' replication-key coalesce(date_modified, date_created)

Is there a way to do it ? I've also tried

RUN meltano config tap-postgres set _metadata 'public-metric_value' replication-key date_modified if date_modified else date_created

The easiest way to maintain meltano imo is to have your meltano.yml be setup with what you want, then run that meltano.yml file in production. It seems like you're running

meltano config etc

every run, while you can do that it's really not needed. In regards to how to set multiple replication keys that's not a thing I think any tap I know of supports.

Yeah, but the problem is that our meltano.yml file is autogenerated in production... I will have to do a lot of cleaning, this project is kind of a mess.