Six Stars


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.


Re: tRedshiftRow


Are you able to parse the results using tParseRecordSet component?

Best regards



Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: tRedshiftRow

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.