Hi All, is there any way that we can dump whole message from topic in one column, my use case is that we have very complex avro-schema , and to create schema and map every field is very tedious work. I have done some transformations using tranformationConfigs but for every topic and schema it is going to be very complex.

There is avro to Pinot schema utility in tools you can use to get a starting point, and then customize it. You can also programmatically generate it for your customizations

You can also store complex fields as Json in Pinot and use json index