AWS Redshift S3 download data

Question

So, I am trying to load data into my Redshift database from an S3 bucket. I have an Example table that has a timestamp field in the format YY-MM-DD HH: MM: SS.

Using a copy of the request to load the data, so I can download a specific pattern / prefix, but I want to load the data after a certain timestamp, say more than "2014-07-09 10:00:00". How do I approach this?

Answer 1

You have two options:

• , S3 ( $SOME_TIMESTAMP)

• COPY ( - ), :

  insert into YOUR_ORIGINAL_TABLE (select * from YOUR_TEMP_TABLE where timestamp > WHATEVER_YOU_NEED)