Google is free since they sell your data. Clickhouse is expensive, compute on scale is expensive, development is expensive etc. Sounds like your best bet is to

Google is free since they sell your data. Clickhouse is expensive, compute on scale is expensive, development is expensive etc. Sounds like your best bet is to do self-hosting