Giving meaning to 100B analytics events a day with Kafka, Dataflow and BigQuery
Sounds like they over-engineered the solution. If you have ad-hoc use-case, BigQuery is great but it&#x27;s quite expensive. If you just need to pre-calculate the metrics using SQL, Athena &#x2F; Prestodb &#x2F; Clickhouse &#x2F; Redshift Spectrum might be much easier and cost-efficient.