Talend : running multiple SQL statements using database row component (example aws redshift tRedshiftRow)
Problem - You might need to run more than one statement in tRedshiftRow (or any other database Row component in talend).
Solution - You can do this by writing your statements in a single string separated by the statement separator for the DB you are using for redshift its ; and i guess for most its the same.
I majorly issue vacuum and analyze commands for my db tables as last job of my load.
example below - just below sql in tREdshiftRow component and it will execute it as multi-statement sql.
"vacuum table1;
vacuum table2;
vacuum table3;
"
vacuum table2;
vacuum table3;
"
