Copy data between Redshift databases (same or remote servers)

My challenge was to copy data from one Redshift database to another, in this case on the same server instance. This solution works well for remote instances, too.

I tried to find a native ‘sql’ solution to the problem and found some tips of using dblink, but they did not work with Redshift.

Continue reading