From an AVRO data source I want to make a DataFlow to keep some of the AVRO data in a PostgreSQL database.
I have already managed to undo the JSON from the AVRO and put each element in a column.
However, this data seems to be in array format because when I try to connect to the sink (PostgreSQL with its table already created and with all the columns matching the JSON elements) I get the following error.
Does anyone know how to solve it, I understand that the array would have to be removed, if so, how could I do it?
Thank you in advance