Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

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

Highlighted

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?

1 REPLY 1

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

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.

Don't have an account?
Coming from Hortonworks? Activate your account here