How can I sync 2 mongo collections keeping object ids and without casting _id to string?

UserBird Dataiker, Alpha Tester Posts: 535 Dataiker

I'm facing an issue trying to sync 2 mongo collections for which I checked the dataset connection option "Import object ids". If I sync a collection A in which I have ids of type "ObjectId" with a new (empty) collection B, the field _id of every objects in my collection B are casted to string (instead of keeping the original type ObjectId).

I tried to modify the schema of the two datasets to explicitly specify a type Object for the field _id but it is still casted to string when syncing.

My question is : how can I sync two mongo collections keeping ids of type ObjectId?

Setup Info
      Help me…