Download Function

[niklasvm]

This is a feature request more than an issue.

I'm interested in a function that can be used to download the contents of a table or results of a query using the reverse of the pattern used for rs_append_table.
i.e. Redshift --> S3 --> Local

My main motivation is that a normal download via a SELECT query can take very long for large results.

[sicarul]

Have you been spying on me? 😝 I swear to you i had the same idea a few weeks ago, i will get to it as soon as i can.

[niklasvm]

Awesome thank you!

[BenoitFayolle]

Might be useful for the project, I've created a unloadToS3() function that'll do the first step of this feature. See my fork if interested.
The feature I needed was the ability to move tables from one RS cluster to another RS cluster (via S3, no local). Essential for huge tables. My rs_move_table function is still very hacky at the moment but it works for me..
All and all thanks for the package @sicarul ! Very useful