Data Warehouse reports can be scheduled daily. You would have selected the Time Period greater than a month and thus 'Daily' option in Scheduler would not have listed. If you selected the Time Period to Yesterday or Last 7 days or anything within a month, you can see the option to schedule it daily.
I know that we can use SFTP for Data Warehouse requests but pretty not sure about s3.
Thanks Arun, that's good to know. With the Data Warehouse reports, is there a way to have all segments included (or would the report creator have to go back in and add new sections to the report as the segments are created?)