Using Talend to Load data into Redshift

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

Using Talend to Load data into Redshift

Using Talend to Load data into Redshift

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

Leave a Reply