Hi, Why is old data being deleted from target and ...
# troubleshooting
s
Hi, Why is old data being deleted from target and only latest file data is overwritten in Target table, I am loooking to do incremental replication
Copy code
extractors:
  - name: tap-mysql
    variant: transferwise
    pip_url: pipelinewise-tap-mysql
    metadata:
      '*':
        replication-method: LOG_BASED
  loaders:
  - name: target-snowflake
    variant: meltanolabs
    pip_url: meltanolabs-target-snowflake
t
I think your
select
pattern may need to be
'<schema_name>-*'
It's probably not matching any tables and using FULL_TABLE replication
Though the logs will say what it's doing so that will be easy to prove/disprove