loaders:
  - name: target-jsonl
    variant: andyh1203
    pip_url: target-jsonl
  - name: target-postgres
    variant: transferwise
    pip_url: pipelinewise-target-postgres
    config:
      host: ${SYSTEM_DB_IP}
      port: 5432
      user: postgres
      password: ${SYSTEM_DB_PASS}
      default_target_schema: raw__${MELTANO_EXTRACTOR_NAMESPACE}
      dbname: dwh
      primary_key_required: false
  - name: target-postgres-meltanolabs
    inherit_from: target-postgres
    variant: meltanolabs
    pip_url: git+<https://github.com/MeltanoLabs/target-postgres.git>
    config:
      host: ${SYSTEM_DB_IP}
      port: 5432
      user: ${SYSTEM_DB_USER}
      password: ${SYSTEM_DB_PASS}
      default_target_schema: raw__${MELTANO_EXTRACTOR_NAMESPACE}
      database: dwh
      hard_delete: true