If you relax your constraint to "retain logs for the past N days", you can accumulate the logs from T=0 to T=(today - N) into tables and still benefit from having snapshots from that cutoff onwards.

On the contrary, I’ve known plenty of sites that keep their logs.

Often written to tape, for obvious reasons.