How to copy data from S3 bucket to Redshift database

[Anonymous]

Hi
Which component I should use to copy the uploaded files on s3 bucket to the redshift database.If possible please share screenshot.

[Anonymous]

My Talend DI 5.3 keeps on crashing after I create some jobs. I had to reinstall fresh copy again. This is the error in the log file. I am running this on Windows 8.1
!MESSAGE An error occurred while automatically activating bundle org.eclipse.emf.ecore (380)
PLEASE HELP!!!!

[Anonymous]

Hi Max_Hamlet,
You'd better open a new forum for your topic.
For your scenario, did you use any custom component in your specific jobs? Is it normal before? Is there any more error log which is saved in <Talend Studio installation path>/workspace/.metadata/.log.
Best regards
Sabrina

[_AnonymousUser]

Hi
Solved the problem through using tpostgresqlrow component  and added copy command in query.

Thanks
Ashish.s

Hi Ashish,
Can you please provide the syntax which you have used to copy the data. Writing simple copy command gives an error of Must be a super user to execute copy operation.
Thanks
Ravi

[Anonymous]

if you're using Talend 6 and above , Talend supports Bulk Load using S3 natively.
I have put an example and a comparison on the performance by using S3 and without it ( JDBC )
https://talendexpert.com/using-talend-load-data-redshift/
The component you should us for Bulk Load is : tRedshiftOutputBulkExec