chrish
09/04/2022, 1:23 PMcsv
files that I am extracting with tap-csv
and loading with target-postgres
.
As I mentioned, these files are static and I don't want to append the same data to my tables every time I run meltano run
.
It looks like I could perhaps use --state-id
if I were using meltano elt
, but I'm running on Windows and that argument is not supported by meltano run
.
Are there any brilliant ideas for essentially mirroring the CSVs? Right now, I manually empty the tables before loading, but obviously that's not ideal, and I'd rather not automate the emptying of the tables because that will disrupt users who are relying on them.