Can we unload data from redshift to different S3 folders based on a field

Question

I have a 100 weeks(week 1 to 100) of data and i want to load this into 52 different folders. This is the file path i desire:

File path 100 : Week 100 - Week (100-52)

File path 99 : Week 99 - Week (99-52)

.

.

.

File path 53 : Week 53 - Week (53-52)

I want to do all this preferably using a single unload.

Answer 1

You can partition an UNLOAD - see: https://docs.aws.amazon.com/redshift/latest/dg/r_UNLOAD.html