I would like to add a sql query result to attributes but I don't see a way to do this currently. Anyone know of a processor I am missing or have a workaround?
Preferably the result columns would become attributes. I think I coooouuld use exctract test to move the current flowfile contents into an attribute, runthe query with ExecuteSQL, convert to json from avro, ExtractJsonPath the columns I want then use ReplaceText to bring the original flowfile back... but that seems excessive and it requires putting the larger of the 2 contents in an attribute. Thanks and Happy Thanksgiving Nifi-Users, Nick
