Basically like a persistent view of data which gets modified when the original table changes? Glad to see more data science friendly features being added. Been watching Clickhouse for a while now and I am very impressed.
But it's more than that. One neat thing is that it can handle incremental aggregations, such as AVG, SUM, and Percentiles, which would not be doable just with insert triggers. ClickHouse can do this because it stores the intermediate state of the aggregations in special Aggregate Function data types.