Hi,
I have a kafka source is json string with column headers and column values and it has inconsistent schema naming sometime with ‘_’ and sometime with ‘-’. Is there anyway to allow both column names into one destination table ?
ex:
Source json-
event
{
“xx_id”: 123,
“aa”:“zxc”
},
{
“xx-id”: 345,
“aa”:“qqr”
}
Destination table
xx_id aa
123 zxc
345 qqr