1 réponse
- Le plus récent
- Le plus de votes
- La plupart des commentaires
1
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.
Contenus pertinents
- demandé il y a 7 mois
- demandé il y a un an
- demandé il y a 6 mois
- AWS OFFICIELA mis à jour il y a 3 ans
- AWS OFFICIELA mis à jour il y a 10 mois
Thanks for helping me out. I really appreciate that!