HI! I'm trying to move data from MongoDB to Postgres and I keep getting errors. What works: • mongodb -> json • json -> postgres I've tried multiple tap-mongodb * target-postgres variant combinations. Right now, I'm using

target-postgres meltano

and it gives this error:

Exception: A record for stream steam was encountered before a corresponding schema

When switching to

target-postgres transferwise

I see SQL command

CREATE TABLE IF NOT EXISTS tap_mongodb."steam" (PRIMARY KEY ("_id"))

which, of course results in

psycopg2.errors.UndefinedColumn: column "_id" named in key does not exist

I think that problem might be somehow related to

tap-mongodb

schema recognition (I've got 4 dummy records there, with

_id, x, y

fields each).

(.venv) me@mypc:~/meltano-projects/m1$ meltano select tap-mongodb --list
2022-03-31T23:18:14.847758Z [info     ] Environment 'dev' is active
Legend:
        selected
        excluded
        automatic

Enabled patterns:
        *.*

Selected attributes:

Could you please help me? :)

hi @krzysztof_sazon you still need help with this problem?