Hello everyone! Here trying to insert data to clickhouse from a nested mongo json document. So my question is that, is it possible to add a column to base table as “documents.drivingLicence” instead of creating separate table "accounts_documents" table.

accounts

{
    "_id" : ObjectId("xxxx"),
    "clientId" : "xxxxx",
    "areaCode" : "xx",
    "gsm" : "xx",
    "status" : "approved",
    "createdAt" : ISODate("2022-05-26T15:35:44.113+0000"),
    "updatedAt" : ISODate("2022-06-27T10:22:07.959+0000"),
    "document" : {
        "drivingLicence" : "approved",
        "video" : "approved"
    }
}

Hello Kaan Murzoglu, it's been a while without an update from us. Are you still having problems or did you find a solution?

@Marcos Marx (Airbyte) We are still having problems 😕

Hello Marcos 🙋🏼‍♀️ I am also facing the same issue, is there any solution that you can recommend to us?

Hello @Marcos Marx (Airbyte), do you have any update for this issue?