Hi, I am facing this issue, probably something wrong in my config. Appreciate any help here. Using Postgresql extractor:

- name: pdr
    inherit_from: tap-postgres
    variant: transferwise
    pip_url: pipelinewise-tap-postgres
    select:
      - "*.*"
    metadata:
      'pdr-tbl1':
        table-key-properties: [id]
        replication-method: INCREMENTAL
        replication-key: id
        key_properties:
        - id

I am getting error:

"time=2023-07-14 16:16:21 name=target_snowflake level=CRITICAL message=Primary key is set to mandatory but not defined in the [pdr-tbl1] stream", "level": "info", "timestamp": "2023-07-14T20:16:21.615492Z"} 
raise Exception(\"key_properties field is required\")", "level": "info", "timestamp": "2023-07-14T20:16:21.620404Z"} 
"Exception: key_properties field is required", "level": "info", "timestamp": "2023-07-14T20:16:21.621079Z"}

key_properties

is available but not getting recognized.

Does the pipelinewise variant of tap-postgres support the table-key-properties option? I don't see anything in it's docs (here) that says it does.

found the issue. My source was a view. Using

view-key-properties

worked for me.

Huh. Cool! Glad you found it, and thanks for sharing!