I am trying to load a csv file with headers with exactly same spelling and caps as in the PostgreSQL DB table.
The table name is different in than the one which you are trying to load data.
Please notice carefully that the error in Nifi is complaining about below table, whereas in your create table there is no prefix with the name "op"
Hey that's a mistake in my typing as I had to mask col and table name. That's not an issue. Can you find anything else? It would be a good help in solving this then.
@Raj2cool16 Can you update the original post, or send a reply here, showing the processor configuration and associated reader configurations? I believe there are some settings in the Processor and the Reader to effect your issue.
If this answer resolves your issue or allows you to move forward, please choose to ACCEPT this solution and close this topic. If you have further dialogue on this topic please comment here or feel free to private message me. If you have new questions related to your Use Case please create separate topic and feel free to tag me in your post.
PFB the full configuration details of PutDatabaseRecord and CSVReader.
PutDatabaseRecord SS Part 1:
PutDatabaseRecord SS Part 2:
CSVReader ss part 1:
CSVReader ss part 2:
CSVReader ss part 3:
Please let me know if anything else is needed, also if I need to tweak on settings or add/remove processors.