Support Questions

Find answers, ask questions, and share your expertise
Celebrating as our community reaches 100,000 members! Thank you!

How to push data from aws s3 to redshift using NIFI?


I'm still a newbie to NIFI, and currently in progress of exploring the uses of some of the processors.

Is there any way to push data from s3 to redshift using NIFI?

What have I done up to now is, I have simply merged two csvs from s3 and stored it in another bucket as one file. I was able to merge two csvs using the MergeRecord processor.

But what I don't know is, how to push data from S3 to Redshift tables?


New Contributor

I'm surprised no one has answered this. You don't really need to use Nifi for this. Read up on the "copy" command for Redshift. You can import from S3 directly into Redshift.