tDBOutput(Amazon Redshift) doesn't work

[MoMoAC]

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

[Anonymous · Accepted solution]

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

[MoMoAC]

Thank you so much. It worked !!!

[Anonymous]

Hello,

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

Best regards

Sabrina