Replacing cron jobs and dbt pipelines with ClickHouse Refreshable Materialized Views
For ClickHouse to achieve the speed it's known for, it has historically relied on a trigger-based and incremental architecture for materialized views. This architecture is known to be very efficient but lacks flexibility, such as when working with data that needs to be backfilled rather than append-only.