Hi. We use tRedshiftRow to do data manipulation inside the database and to load data (using copy command).
Is there a way to grab the output that Redshift returns?
If not, is there a better way to be doing those operations?
Right now it's not even possible for me to tell whether the query succeeded or not.
Are you able to parse the results using tParseRecordSet component?
If you insert, update, or delete a significant number of rows in a table, relative to the number of rows before the changes, run the ANALYZE and VACUUM commands against the table when you are done. If a number of small changes accumulate over time in your application, you might want to schedule the ANALYZE and VACUUM commands to run at regular intervals. mobdro.io