Meltano

I’m trying to configure `tap_postgres` but can’t quite get the yaml right :thread:

This is my yaml
```  - name: tap-postgres--terry
    inherit_from: tap-postgres
    config:
      filter_schemas: terry
    select:
    - campaigns.*
    - notifications.*
    - vouchers.*
    metadata:
      '*':
        replication-method: INCREMENTAL
        replication-key: updated_at```

Untitled

Note that I cannot easily dump the catalog as the db is in a secure subnet accessible only from where the jobs run :confused:

I’m assuming you’re able to access and send queries to the database from that subnet already using the same user, right <@U06C8RU9AAZ>? Just trying to eliminate a permissions issue.

Have you set a dbname <https://meltano.com/plugins/extractors/postgres.html#dbname> ?

Yeah I’m going to go thru the annoyance of creating a bastion and a prviate test instance and stuff and i’ll see what it was