title: Redshift unload's file name
body: <p>I'm running a Redshift unload command, but am not getting the name I desire.  The command is:</p>
  
  <pre><code>UNLOAD ('select * from foo')
                   TO 's3://mybucket/foo'
                   CREDENTIALS 'xxxxxx'
                   GZIP
                   NULL AS 'NULL'
                   DELIMITER as '\t'
                   allowoverwrite
                   parallel off
  </code></pre>
  
  <p>The result is mybucket/foo-000.gz.  I don't want the <strong>slice number</strong> to be the end of the file name (it'd be great if it can be eliminated completely), I want to add a <strong>file extension</strong> at end of the file name.  I'd like to see either of the following: </p>
  
  <ul>
  <li>mybucket/foo-000.txt.gz </li>
  <li>mybucket/foo.txt.gz</li>
  </ul>
  
  <p>Is there any way to do this (without writing a lambda post process renamer script)?</p>