I am reading CSV files from an SFTP site and loading it to mysql db. I have the below workflow which seems to be working fine. I just need some help in figuring out how to truncate the table before i start with the data load. Nifi Flow: ListSFTP -> FetchSFTP -> InferAvroSchema -> ConvertCSVtoAvro -> ConvertAvrotoJSON -> SplitJSON -> ConvertJSONtoSQL -> PutSQL This flow seems to work fine, but every time i run this, i need the table to be truncated first and then start the load. Can someone please help me with some info on how i can achieve this. Or is there a better flow than what i have written, please advise. Thanks, Aadil ... View more