How We Built a Data Warehouse Using ClickHouse
Summary
This piece documents Lets Encrypt's move to a self-hosted data warehouse using ClickHouse to analyze issuance and log data at scale. It covers hardware choices, data modeling with ReplacingMergeTree, materialized views, backfilling logs via an S3 gateway, and faster, pre-aggregated analytics for the public stats page.