We currently default to 1 week and tell users to customize it using alter table default.flows_raw modify ttl Date + toIntervalDay(20).
https://github.com/monogon-dev/NetMeta/blob/2bab7d91da7c8fd97e8a414989f42c8b8dfd2b69/deploy/single-node/schema/0001_create_flows_raw.sql#L79
Now that we auto-reconcile, we should make this a config item and have the reconciler apply it automatically (+making sure it gets applied to old partitions, maybe CH even does this automatically now).