Hi, I wonder if there is a way to truncate the destination table data before loading from the source table data. For example, Postgres to Postgres, Postgres to Oracle, etc

Have you looked at activate_version? https://hub.meltano.com/singer/docs/#activate-version Still a feature in development, not an official part of Singer AFAIK.

@Andy Carter how to apply it in the project file?