I am using Nifi to load CSVs, apply a new schema and load them into a SQl db. Currently I am writting an Avro schema, and applying the schema to each CSV. I am writing the schema based on the order of the incoming CSV- the first field = first column in CSV. Is there a way to map one schema to another? I.e. can I say 'csv.name -> sql.username'.
I have read about recordpaths and update records. I am looking for something to match the whole incoming schema to a new schema, not based on order.
... View more