Posted about this yesterday in troubleshooting but...
# troubleshooting
g
Posted about this yesterday in troubleshooting but I'll try something maybe a little easier than just posting my whole YAML. I've narrowed down my issue (I think?) Any reason why target-postgres would not load the following streams without a default mapped schema? I originally tried using a default schema but kept mapping to one schema despite the one override. Is there something else I should do here?
Copy code
loaders:
  - name: target-postgres
    variant: transferwise
    pip_url: pipelinewise-target-postgres
    config:
      user: postgres
      dbname: dbt
      host: 192.168.1.30
	  port: 5432
      schema_mapping:
        payment: 
          target_schema: stripe
        customers:
          target_schema: payment
I think the target is seeing the correct stream names incoming?
Copy code
{"type": "SCHEMA", "stream": "customers", "schema": {...
{"type": "SCHEMA", "stream": "payment", "schema": {...