Meltano

Hi everyone, does any of you know if the `load_method` built-in setting works for `target-postgres` (<https://github.com/MeltanoLabs/target-postgres>)?

It’s documented in the README file, but I have been testing different configurations and it doesn’t seem to work as expected. Curious if there’s support for `overwrite` method and/or if there’s any alternative to achieve that other than implementing it by myself.

Thanks!

Load method is put in by the SDK, it should get removed from target-postgres I think.

activate_version is supported and the way you'd accomplish overwrite through the target itself, so the tap would have to send activate_version messages

Do you have an example of how the config for tap-target should look like?

I have tried using multiple combinations of `activate_version` and `hard_delete`, however it had no effect.

Ohh I just saw in the docs this capability is not supported by default, that’s probably why it’s not working.

It's up to the tap providing the activate_version message that's probably the reason

I think same same though! You found it :confused: sorry