Hi, I need to change the destination for all my connectios from postgresql to redshift. Is it possible to do without loosing the data I already have and without setting new connections with the new destination?

@[DEPRECATED] Marcos Marx turned this message into Zendesk ticket 2830 to ensure timely resolution!

Deleting the connection doesn't delete data from the source or destination, so that would not be lost, however you would need to create a new connection for the new destination

Thanks. Do you have estimation on how muy faster is using S3 staging in redshift destination instead of standard staging on Redshift?

We don't have any docs on this specifically but S3 staging uses

COPY

which allows loading data in parallel, as opposed to the default

INSERT

. So it could potentially be exponentially faster depending on your infrastructure 🙂 There is a little more investigation in this stackoverflow post