I have a problem with the `load_method: overwrite`...
# troubleshooting
l
I have a problem with the
load_method: overwrite
in a target-postgres. It seems to not do what is written in the documentation. As I understood it should drop the full table or at least all entries and insert all data from the tap. Currently it is not deleting any data. Am I missing something. This is my loader:
Copy code
- name: target-postgres-full-load
    inherit_from: target-postgres
    variant: meltanolabs
    pip_url: meltanolabs-target-postgres
    config:
      activate_version: false
      add_record_metadata: false
      default_target_schema: public
      load_method: overwrite
      batch_size_rows: 100000
      validate_records: false
v
load_method
really shouldn't be listed as a config for that target 😕
l
And what would be my out to get data to be deleted?
v
I use dbt and drop the tables https://medium.com/@danielpdwalker/handling-hard-deleted-data-from-source-5578e67f5a0c is a good write up for this!
1
👍 1
meltano run dbt:drop_schema tap-name target-postgres-full-load
l
Ok will try this way. Thank you so much for the fast reaction.