Originally from the User Slack
@Guillaume_Lorin: Hello everyone!
I have a table setup with TWCS compaction and a table default TTL of 1 year. I want to reduce the TTL on this table to 1 month, and right away delete all the previously-inserted-data that is older than that to save disk space.
So I understand from the documentation that data written before the change is not affected by the new TTL. And running DELETE is not recommended with TWCS. So I was wondering if there is a recommended strategy to delete it safely? Or should I just start a new table ?
@Felipe_Cardeneti_Mendes: You can also change the compaction strategy temporarily. But given the problem at hand I guess I would just create a new table and switch past your TTL period