Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
most realistic reason for this - forgotten "auto-commit" check-box in connection properties
if You do not want use auto-commit, You could use tRedshiftCommit component at the end of Job
most realistic reason for this - forgotten "auto-commit" check-box in connection properties
if You do not want use auto-commit, You could use tRedshiftCommit component at the end of Job
That is exactly what it was, thank you very much!