I have to copy the data from one Redshift Table to another Redshift Table.
I used tredshiftrow->tredshiftInput->tredshiftOutput.
It is working but the data transfer is 67 rows/sec which is **bleep** slow.
i have around 4 million rows and this logic is taking forever.
I can not used tredhiftoutputbulkexe because i do not have S3.
Apart from that,i did all the things like setting 'Cursor size','commit every',taking the data to a file and then to transfer to TredshiftOutput Db but in every case speed is very slow.
Could you please let me know if there is any other method that i could try?
