title: Amazon redshift older data retrieval
body: <p>If I have a dataset loaded in redshift which is being updated daily, so how can I retrieve it or store my older data to get it whenever I need it for my analysis.</p>
  <p>For example, if I run a query on 1st Jan 2020 I'll get an output to let 'X', and since the data is being updated regularly by the inclusion of new rows and updating records of the current ones also,
  so now when I'll run the same query on 1st Feb 2020 I'll get a different output 'Y'.</p>
  <p>Now I need to compare both 'X' and 'Y' output for comparison, but I'm unable to retrieve the 'X' output on 1st Feb 2020, since the data has been updated.</p>
  <p>That's why I need a way to retrieve older data or a way to store that data in Amazon redshift.</p>