I have downloaded @Andrew Grande's nifi-csv-bundle and had a few questions about its use. Can someone explain the relationship between the attributes "Record Source From Attribute", "Input Schema Attribute Prefix", and "Output Attribute Prefix" along with their proper use? I am parsing individual CSV lines that aren't being sent with a header, but they're in a fixed-order which I'd like to map to individual attribute names corresponding to SQL column names.
I was also wondering if all attributes are cast as strings by default? I want the attributes to correspond to their respective mysql datatype for when I prepare the INSERT statement. Does the ParseCSVRecord processor support Nifi expression language? If so I could coerce the input to its proper datatype.