the use case is, I want to maintain an aggregated data about customers doing txns on a daily basis
CREATE TABLE compute_by_customer( customer_id text, txn_date date, txn_amount counter, txn_count counter, PRIMARY KEY (customer_id,txn_date) );
The application queries deal with current_date and recent dates of customer transactions, hence I do not want to maintain records that are past 30days.
Since txndate is associated, there will never be a case where a past dated txn can be performed by a customer, hence information about a particular record remains intact after the date is passed.
How can I set TTL or the workaround in this scenario?