I have created a pipeline that gets JSON messages from Kafka into stored procedure where stored procedure gets generic_json which is of type JSON.
I have used generic_json <- % in my pipeline create statement because fields in JSON messages are dynamic
I know I can extract value if I know path/name of the field. I do not have any nested JSONs.
How can I extract field name (Since I do not know before hand) and it’s value so that I can store them as name/value pairs in my table.