daniel_walker
09/07/2021, 10:38 AMACTIVATE_VERSION
as my singer table replication method, or using the Target Postgres variant transferwise to take advantage of the _sdc_
metadata columns, then use dbt snapshots and so on.
My question is, has anyone found/know of a work around to completely refresh a tap's stream table every sync? I could then just snapshot this table and capture deletes that way.
Also are there any other methods for capturing hard deletes that I've missed?
Wanted to see if this was a think before I commit to the whole ACTIVATE_VERSION
refactor that I think I'm going to need to do.
Thanks