Hi there @MathieuSF,
writing to CSV file on S3 from within KNIME still requires Upload node but with new file handling concept (for example Excel Writer already has this option, see here for more) this should work almost as you designed it in your workflow 
Stay tuned!
Br,
Ivan