v.24.10Experimental Feature

Refreshable Materialized Views Now Supported in Production for Replicated Databases

Refreshable materialized views are production ready. #70550 (Michael Kolupaev). Refreshable materialized views are now supported in Replicated databases. #60669 (Michael Kolupaev).
Refreshable materialized views are now production ready and supported in replicated databases in ClickHouse.

Why it matters

This feature enables materialized views to be refreshable and consistent across replicated environments, solving synchronization and data freshness problems, thus improving data reliability and maintenance in distributed setups.

How to use it

To use refreshable materialized views, create a materialized view with the REFRESH clause in a replicated database. The views will automatically keep data synchronized and refreshed according to the specified configuration.