Hi, we were having the same problem in the tRedshiftOutput component, and found that when we unticked the 'extend insert' option under its advanced setting, and added a row -> main after the tRedshiftOutput to a tRedshiftCommit (untick the auto close connection), then the job ran without any issues.
I am also facing the same issue. In logs, it is showing data is getting inserted, but actually in Database data is not getting loaded. MY query is tRedshiftCommit makes use of "component List". I have not defined this component list as of now, as this is first time i am running my job connecting to Redshift database. Can you show your job design how to use/connect this component tRedshiftConnection in existing JOB flow?
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables