I need to be able to dump the contents of each table in my redshift data warehouse each night to S3.

The outcome that I want to achieve is the same outcome as if I was manually issueing an UNLOAD command for each table.

For something this simple, I assumed I could use something like data pipeline or glue, but these don’t seem to make this easy.

Am I looking at this problem wrong? This seems like it should be simple.