Hello Community,
I am going to keep this short, I am interested in looking into using dynamic schemas for JSON data parsing. I have an Oracle DB that has JSON Strings stored into one of the columns. There are 2 columns in total, a message/payload column and a header column, the payload column include the row's columns and relative inputs, the header contains he object name as well as some other metadata. As such, my JSON inputs come in many slightly differing schemas, i.e.: some have ID, First Name and last Name, while another strings includes the same fields but with the addition of address for example. Knowing that my payloads would be random and could suddenly have an increase or decrease in number of fields due to changes in front end and data collection, how can I account for that automatically in my job?
P.S.: I am aware that dynamic type columns are unavailable for JSON based inputs/outputs but I was hoping for some assistance in finding a work around.
Thank you for your time!
Sam
