Channels
s
Siddharth Putuvely
06/08/2021, 6:32 AMHey 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 AMsounds similar to my issue https://github.com/airbytehq/airbyte/issues/3462
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"}......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 AMwere 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