INGST-06: ClickHouse TTL for automatic 30-day data expiry #6

Closed
opened 2026-03-11 11:13:16 +01:00 by claude · 1 comment
Owner

ClickHouse TTL automatically expires data after 30 days (configurable retention period). Uses partition-level TTL (ttl_only_drop_parts) for efficient cleanup.

Category: Data Ingestion
REQ-ID: INGST-06

ClickHouse TTL automatically expires data after 30 days (configurable retention period). Uses partition-level TTL (`ttl_only_drop_parts`) for efficient cleanup. **Category:** Data Ingestion **REQ-ID:** INGST-06
Author
Owner

Implemented in Phase 1. ClickHouse schema in clickhouse/init/01-schema.sql includes TTL expressions on all data tables. TTL is configurable via ingestion.data-ttl-days property (default 30 days). Key files: 01-schema.sql, application.yml.

Implemented in Phase 1. ClickHouse schema in `clickhouse/init/01-schema.sql` includes TTL expressions on all data tables. TTL is configurable via `ingestion.data-ttl-days` property (default 30 days). Key files: `01-schema.sql`, `application.yml`.
Sign in to join this conversation.