Data Management

Back to Settings Help
Configure ClickHouse TTL for automatic data expiration, S3 backup scheduling with optional encryption, and backup-TTL coupling to ensure expired data always has a backup on record. Backup and restore features are optional and can be disabled entirely.
Database Stats & Retention
Database Stats
Compressed size 4.1 KB
Uncompressed size 9.4 KB
Compression ratio 2.28×
Total rows (active parts) 21
Active queries 1
Top tables by size
TableSizeRatioRows
sobs_chart_configs 1.7 KB 4.14× 4
sobs_anomaly_rules 1.6 KB 1.01× 10
sobs_app_settings 440 B 1.36× 6
sobs_dashboards 368 B 0.49× 1
ClickHouse TTL

Set TTL (time-to-live) values for each telemetry table. After saving, click Apply TTL to Tables to immediately execute the ALTER TABLE … MODIFY TTL statements. Leave a field blank to skip that table. Changes take effect on the next ClickHouse merge cycle.

Table: otel_logs
Table: otel_traces
Tables: otel_metrics_*
Table: hyperdx_sessions
TTL–Backup Coupling

When enabled, the data management page displays a warning whenever a configured TTL window is shorter than the backup retention implied by your schedule. This is an advisory indicator only — SOBS does not block TTL or backup operations.

Leave period blank to prune using current table TTL settings only.
Backups & Storage
S3 Backup
When disabled, the backup and restore API endpoints return 403. TTL settings are always available regardless of this toggle.
Full S3 endpoint URL or bucket name. E.g. https://s3.us-east-1.amazonaws.com/my-sobs-backups
No secret access key is currently stored. Stored encrypted if SOBS_SETTINGS_ENCRYPTION_KEY is configured.
Enables ClickHouse native encryption for backup archives written to S3.
Backup Schedule (documentation)

SOBS does not run an internal scheduler. Record these cron expressions in your external scheduler (cron, Kubernetes CronJob, GitHub Actions schedule, etc.) and call the POST /api/data-management/backup/run endpoint with {"type":"full"} or {"type":"incremental"}.

Weekly Sunday at 02:00 UTC
Mon–Sat at 02:00 UTC
Quick Cron Builder

Generate cron strings and apply them to the fields above.

Cancel
Backup and restore controls are hidden until Enable Backup & Restore is enabled and saved.