Hi
I have a use case where I get json message from kafka and it dosnt have fixed schema
Json can have nested fields or an array
Is there any way/suggestions to handle dynamic json and then save it as iceberg table
m
Martijn Visser
09/06/2023, 3:40 PM
I guess you would just use your favorite JSON library/parser and implement all the logic yourself?
p
Prashant L
09/06/2023, 3:41 PM
Yeah that should be the only option I feel
m
Martijn Visser
09/06/2023, 3:42 PM
That's what you get when you get garbage data in π
p
Prashant L
09/06/2023, 3:44 PM
Actually we are building a datalake which injest data through rest api kafka
So it's a common rest api used by different teams to ingest different data and not every payload will have common structure
a
Ashish Khatkar
09/06/2023, 4:16 PM
Schematize the data. It will save you from lot of issues in future