title: Data load from Amazon S3 to Redshift using Copy Command - How to store Time of copy in Redshift
body: <p>I am using Amazon Firehose to stream online data, apply transformation using Lambda and load data to Redshift through S3. The COPY command in Firehose is:</p>
  
  <pre><code>COPY &lt;TABLE NAME&gt; FROM 's3 Location' CREDENTIALS 'IAM ROLE' MANIFEST json 'auto' gzip;
  </code></pre>
  
  <p>I am interested in knowing the exact time at which the S3 to Redshift copy is made by Firehose, so that I can store the same in Redshift and use it for future references. How do I get the time while doing copy command?</p>
  
  <p>Example: If I have a Data Pipeline job, I will get <code>sysdate</code> and then  insert it into the Redshift table. How can I accomplish something similar to this in S3 to Redshift Copy? Is there any direct option or workaround for this?</p>