I’m using ClickHouse with a remote MongoDB table defined via the MongoDB table engine. I want to store some core fields as separate ClickHouse columns (like _id, client_id, room, created_at) and also keep the entire MongoDB document as a single column (including both the core fields and any dynamic fields).

I have tried multiple things but I am unable to get the desired results.

How can I correctly store or query the entire MongoDB document as a single field in ClickHouse while keeping core fields separately?