Working on my Open Source MMP I have been seeing how much of it will work with ClickHouse. Unfortunately combining multiple streaming data sources in ClickHouse was proving difficult as data would semi randomly not join correctly. This led to a potential fix by using the very recent ClickHouse refreshable materialized views. These refreshable views…