title: how can I add datetime stamp to zip file when unload data from snowflake to s3?
body: <p>I want to be able to add a timestamp the filename I'm writing to s3. So far I've been able to write files to AWS S3 using example below. Can someone guide me as to how do I go about putting datetime stamp in the file name?</p>
  
  <pre><code>copy into     @s3bucket/something.csv.gz
  from (select * from  mytable)
  file_format = (type=csv  FIELD_OPTIONALLY_ENCLOSED_BY = '"' compression='gzip' )
  single=true
  header=TRUE;
  </code></pre>
  
  <p>Thanks in advance.</p>