We have multiple tables storing all kinds of statistics, which for now are using default Size Tiered CS. As we're witnessing some issues with the stability, we're thinking about switching to Time Window CS, as according to the available information, it's the best option for our use case.
My question is, what requirements should the primary key meet to take advantage of the TWCS? Currently, it's a little bit messy - ((user_id, month), namespace, data_id, timestamp), where all columns, besides timestamp, are strings.
Should the timestamp be a part of the partition key?