I'm usign tap-postgres and target-postgres. In tap-postgres most of the tables are configured to refresh incremental, but some are

full_table

. Since taps and targets don't know about each other by design, when tap sends full_table, target still upserts while keeping the existing records on the target. How do I make it truncate the target for the tables that are configured as full_table refresh?

activate_version is the feature you're looking for

thanks, just read about activate_version: https://hub.meltano.com/singer/docs/#activate-version so, I was usign transferwise version for both tap and target. should I switch to meltano version?

I know target postgres supports it, I'm not sure if it's implemented by default for tap postgres (I didn't do anything special) you can check by dumping the data for a full table pull to a file and looking for an activate version message