Good day everyone :wave: tap-snowflake target-pos...
# troubleshooting
s
Good day everyone 👋 tap-snowflake target-postgres I'm setting FULL_TABLE refresh but tables in postgresql side a not truncated before reload. They accumulate more rows. How do I make target-postgres to emtpy the table before loading. config:
Copy code
plugins:
  extractors:
  - name: tap-snowflake
    variant: transferwise
    pip_url: pipelinewise-tap-snowflake
    config:
      default_replication_method: FULL_TABLE
    select:
    - '*.*'
    metadata:
      '*':
        replication-method: FULL_TABLE

  loaders:
  - name: target-postgres
    variant: transferwise
    pip_url: pipelinewise-target-postgres
    config:
      default_target_schema: <>
      parallelism: 3
      data_flattening_max_level: 1
      primary_key_required: false
      hard_delete: true
      schema_mapping:
        "*":
          target_schema: <>
v
I"m not sure with the pipeline wise variant exactly, but you could try the meltanolabs variant as activate version is tested and should do what you're asking!