redshift: how to unload to s3, and still get a resultset back

Question

I have a query to redshift that gets unloaded to s3, that part is working fine. But it looks like the UNLOAD command does not return anything to my client app.

I want to avoid an extra call afterwards, from the client, to read the results from s3.

Is it possible do both: unload and still get a results set from redshift in one sql query?

Joe Harris · Accepted Answer · 2014-05-23 12:26:50Z

1

No, you have to run 2 statements; one to UNLOAD and one to SELECT the data for the client app.

answered May 23, 2014 at 12:26

Joe Harris

14.1k4 gold badges49 silver badges56 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

redshift: how to unload to s3, and still get a resultset back

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related