PutDatabaseRecord allows you to put multiple records from one flow file into a database at a time, without requiring the user to convert to SQL (you can use PutSQL for the latter, but it is less efficient). In your case you just need GetFile -> PutDatabaseRecord. Your CSVReader will have the schema for the data, which will indicate the types of the fields to PutDatabaseRecord. It will use that to insert the fields appropriately into the prepared statement and execute the whole flow file as a single batch.
I am trying to insert few sample records (.csv) to Teradata using NiFi. My current workflow is same as you suggested
GetFile -> PutDatabaseRecord
but I am getting the error as below. Please advise. Appreciate your help!
Please find the configurations for the 2 processors:
This is how data looks like:
create table bigdata_dl.acct(