I have a CSV file that is generated in a Azure Blob container, i have to record the data from CSV file in table MySQL;
I i got it a solution using this processors:
1 - Use processor ListAzureBlob for list the file in my container;
2 - Fetch file with processo FetchAzureBlob;
3 - Replace the Header and prepare the file for the next step;
4 - input the data into MySQL table;
But I think to have better way to do this. Is it possible to create a table direct in mysql using the csv file by nifi?
This flow seems quite compact already, so I think you are scoring well regarding best practices.
Conceptually, the only step you could eliminate is the transformation, but of course this would require the file to 'fit' as-is into mysql.