topic Re: tDBOutput(Amazon Redshift) doesn't work in Talend Studio

tDBOutput(Amazon Redshift) doesn't work

MoMoAC — Fri, 15 Nov 2024 23:08:28 GMT

I created a job that download a zip file and decompressed the file , then extract the data to Redshift DB.

When I run the job, there was no error message, but the data wasn't updated nor inserted into Redshift DB.

I really don't know why .....

Thank you so much for you hel; !

as shown below : Job flow

as shown below : component basic setting

Re: tDBOutput(Amazon Redshift) doesn't work

Anonymous — Wed, 09 Mar 2022 09:49:47 GMT

Hello,

Please check "Commit Every" option in advanced settings of db output component, and make sure no of rows flowing are grater than that count .

In addition to that, could you please select the "Die on error" check box in the tDBOutput in your job? It will throw the details of the error in more detailed manner.

Best regards

Sabrina

Re: tDBOutput(Amazon Redshift) doesn't work

MoMoAC — Wed, 09 Mar 2022 10:53:26 GMT

Thank you so much. It worked !!!

Re: tDBOutput(Amazon Redshift) doesn't work

Anonymous — Thu, 10 Mar 2022 02:47:56 GMT

Hello,

Great it helps. Feel free to let us know if there is any further help we can give.

Best regards

Sabrina