we have the exact same problem. We tried Clickhouse but their materialized view limitations stopped us.