Clickhouse is expensive, compute on scale is expensive, development is expensive etc. Sounds like your best bet is to do self-hosting