Another one for the `tap-spreadsheets-anywhere` ex...
# plugins-general
a
Another one for the
tap-spreadsheets-anywhere
experts: can I force it to use
FULL_TABLE
sync mode? Nothing in the config suggests this is possible, or a quick search of the source. We have some spreadsheets where rows are being deleted, so these are remaining in the output tables. EDIT: I think I need to learn about
activate_version
🙂
j
I believe this is a Singer SDK enum. Have you tried running it?
a
There's no key in the config where I would specify, do you mean as part of a
meltano run
command? Not sure of the syntax there, any pointers welcome
j
In meltano.yml file at
plugins.extractors.[*].config
you should be able able to add
Copy code
default_replication_method: FULL_TABLE
or
Copy code
metadata:
  <stream-id>:
    replication-method: FULL_TABLE
or something along the lines. I've never used this tap, but I can try it out, if you have a reproducible example.
Which variant of the tap are you running by the way?
a
ets
I'll try what you suggested thanks, although I think I need a target that supports activate_version to truncate prior data.
f
Hi @Andy Carter and @janis_puris. Im facing the same problem here with this tap. If you make it works, please send the solution here.