Six Stars

tRedshiftOutput using tRedshiftConnection not working?

I have successfully used a tMysqlConnection component ("Use existing connection") with a tMySQLInput component to read from a source database, but I now need to write to a Redshift database, and the tRedshiftOutput component does not seem to create any rows in there while it is set to use the existing connection from the tRedshiftOutput component.

1 ACCEPTED SOLUTION

Accepted Solutions
Ten Stars

Re: tRedshiftOutput using tRedshiftConnection not working?

most realistic reason for this - forgotten "auto-commit" check-box in connection properties

Screen Shot 2017-05-09 at 9.42.33 AM.png

 

if You do not want use auto-commit, You could use tRedshiftCommit component at the end of Job

-----------
2 REPLIES
Ten Stars

Re: tRedshiftOutput using tRedshiftConnection not working?

most realistic reason for this - forgotten "auto-commit" check-box in connection properties

Screen Shot 2017-05-09 at 9.42.33 AM.png

 

if You do not want use auto-commit, You could use tRedshiftCommit component at the end of Job

-----------
Six Stars

Re: tRedshiftOutput using tRedshiftConnection not working?

That is exactly what it was, thank you very much!