Support Questions
Find answers, ask questions, and share your expertise

loading data from csv file to dynamodb using NIfi

loading data from csv file to dynamodb using NIfi

How can i load data from CSV file to dynmaodb using putdynamodb in nifi..?

2 REPLIES 2

Re: loading data from csv file to dynamodb using NIfi

Super Guru

What does your CSV file look like? Does it have 3 columns corresponding to the hash key, range key, and an attribute value?

Re: loading data from csv file to dynamodb using NIfi

Hi @Matt Burgess, i am having some multiple csv files with different schema,just one column is common(lets say id) and they may or may not have matching values. I want to merge them all before sending it to dynamo db and and dont know how can i put them in dynamodb. for example

InputFile 1

deptidfirstnamelastname
1AmanSharma
2RamanVerma

InputFile 2

deptidsalaryemail
120000abc@gmail.com
230000bgf@gmail.com

OutputFile(By merging file1 and file2):-

deptidfirstnamelastnamesalaryemail
1AmanSharma20000abc@gmail.com
2RamanVerma30000bgf@gmail.com