https://linen.dev logo
s

Siddharth Putuvely

06/08/2021, 6:32 AM
Hey guys, I have this MongoDB collection with thousands of docs, which have an id field in them in the form : "_id": { "$binary": "YkrYedM4QKGkq0lkcTZ4pQ==", "$type": "3" }, This is being parsed by airbyte in the string form "#<BSON:Binary0x00007f70d8381350>" How do I configure airbyte to parse it in the form "a8c5b73f-e801-46e0-b722-45b167ac576c" @Aditya Guru
u

user

06/08/2021, 8:03 AM
u

user

06/08/2021, 8:56 AM
@Alex Koshterek We see the data type inferred is a string for our _id field
"json_schema":{"properties":{"_id":{"type":"string"}......
Should that be ObjectId instead?
u

user

06/08/2021, 2:29 PM
@Siddharth Putuvely do you mind creating a Github issue for this? we have a ticket to revamp and stabilise the Mongo connector. your issue and Alex's issue will be part of the work
u

user

06/09/2021, 6:20 AM
@Davin Chia (Airbyte) thanks. Any idea when we can get this fix? Appreciate that. CC: @Aditya Guru
u

user

06/09/2021, 6:22 AM
were you able to create the ticket? we don't have a concrete timeline yet. I'm guessing sometime in the next month. is this blocking you?
3 Views