Hey! Welcome to the Matillion Community!
You might want to take a look at the S3 Unload component. Here's a thread showing another user looking at this in the past. Note that it does require you to store the data in a table before unloading but think this is what you want!
Thanks,
Johnathan