Introduces Refreshable Materialized Views in ClickHouse, allowing materialized views to be explicitly refreshed to update their data.
Why it matters
This feature addresses the need to control when materialized views update their contents, solving the problem of automatic but sometimes untimely or unwanted updates. It enables users to refresh materialized views on demand, providing better control over data consistency and performance optimization.How to use it
Users can create materialized views with the new refreshable option and then use explicit commands or mechanisms provided by ClickHouse to refresh the view data when needed, rather than relying solely on automatic updates triggered by underlying table changes.