BIGQUERY TO CLICKHOUSE AT 15M CALL MINUTES A DAY: WHAT BROKE, WHAT WE FIXED, AND HOW WE CUT COSTS 6X

Summary from the TLDR DevOps newsletter

Bolna migrated analytics from BigQuery to ClickHouse, moved expensive CDC deduplication into materialized views, and fixed missing TOASTed JSONB values with REPLICA IDENTITY FULL. Reducing intermediate application writes cut replication traffic, with Bolna reporting roughly 6× lower analytics costs and data availability improving from 5–15 minutes to 1–2 minutes after calls ended.