Periodically moving query results from Redshift to S3 bucket
<p>I have my data in a table in Redshift cluster. I want to periodically run a query against the Redshift table and store the results in a S3 bucket.</p>

<p>I will be running some data transformations on this data in the S3 bucket to feed into another system. As per AWS documentation I can use the <code>UNLOAD</code> command, but <strong>is there a way to schedule this periodically</strong>? I have searched a lot but I haven't found any relevant information around this.</p>