Not sure if I have something configured incorrectl...
# singer-targets
d
Not sure if I have something configured incorrectly, but when using LOG_BASED replication for tap-mssql and target-snowflake, it wipes the table at the target then loads in nothing since nothing has changed. If I change one record, it just has that single record at the target after running. This doesn't happen when using INCREMENTAL. Any ideas?
e
Hi Daniel. Which variant of tap-mssql is this?
d
The default variant
wintersrd
e
I'm unfortunately not familiar enough with mssql or log_based replication. But do log an issue in the tap's repo.
d
What part of the run determines what should happen at the target? I did log an issue and they said they don't think it's related to the tap. I also checked the source code for the meltanolabs (default) variant of target-snowflake and I don't see anything related that matches
truncate
or
delete
. Given that INCREMENTAL doesn't actually delete anything at the target, and the replication mode is a configuration on the tap, how does the target know if it should delete or not?
👀 1