Using Talend to Load data into Redshift
In this quick post, i wanted to show you how we can load data into Redshift with and without going throw AWS S3.
In this example we are using a small Amazon Redshift cluster size with only one node.
Loading data into Redshift using Bulk Load via S3 :
On the studio , You link your feed directly to the native component of Talend
Now you need to config the component on S3
Make sure the schema correspond exactly to the table in redshift.
hint : keep the Date pattern as Redshift default format