I want to automatically delete records 10 years ago from Redshift on a regular basis


When using Redshift, I would like to create a mechanism to automatically delete past records 10 years ago. Is it possible to set the TTL and delete it regularly like DynamoDB?

asked 2 years ago1097 views
1 Answer

You have to create your own logic to delete data from Redshift tables. If the volume of data to be deleted is not too large then you can create a stored proc and schedule it to run on a regular interval. For large volume tables with lots of records to delete, its better to design tables into time series, this way you can simply drop the entire table containing that time period, making the operation simple and fast. Details are documented here.

answered 2 years ago
  • Thanks for helping me out. I really appreciate that!

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions