Six Stars

tRedshiftRow

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.

2 REPLIES
Moderator

Re: tRedshiftRow

Hello,

Are you able to parse the results using tParseRecordSet component?

Best regards

Sabrina

 

--
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. mobdro.io