Ok I might have figured out what is going on with tap-postgres. It looks like no matter what you put for

table-key-properties

, when

def discover_db

runs https://github.com/transferwise/pipelinewise-tap-postgres/blob/master/tap_postgres/discovery_utils.py#L43 it returns the

db_stream

to stream_utils.py and then line 91 overwrites metadata with the discovery from postgres. https://github.com/transferwise/pipelinewise-tap-postgres/blob/master/tap_postgres/stream_utils.py#L91 essentially changing this:

{'selected': True, 'replication-method': 'INCREMENTAL', 'table-key-properties': [''], 'schema-name': 'public', 'database-name': 'automatedsms', 'row-count': 107, 'is-view': False}

to this:

{'selected': True, 'replication-method': 'INCREMENTAL', 'table-key-properties': ['id'], 'schema-name': 'public', 'database-name': 'automatedsms', 'row-count': 107, 'is-view': False}