Dashboard yang tidak bisa dilayani BigQuery.
Tiga jam: ekspor dataset publik BigQuery, query di tempat dari object storage, lalu kalahkan schema yang diberikan BigQuery sebanyak tiga kali -- pada byte terkompresi, pada baris yang dibaca untuk satu lookup, dan pada funnel konversi per menit yang tidak bisa diselamatkan sort key apa pun.
What you will do
Create a free ClickHouse Cloud account and service and confirm SQL console access -- nothing else to install.
The same question asked of BigQuery and, later, of ClickHouse -- two pre-measured answers, no explanation yet, and a straight statement of where BigQuery genuinely wins.
Read the GA4 export directly out of object storage with no ingestion at all, and feel why that is not how you want to run a dashboard.
Let ClickHouse infer BigQuery's own export schema, ingest it unchanged, and see a working, unremarkable migration.
Five concrete changes to the naive schema, run one at a time, each with the compressed-byte count that proves whether it helped.
One column choice, made concrete with real DDL, that turns a lookup reading almost the whole table into one reading two granules -- measured server-side, not on the console's clock.
A dashboard that groups every row in its window, not one user's history. No sort key rescues it -- the fix is an incremental materialized view with no BigQuery equivalent, built here with real DDL.
Use the SQL console's built-in agent against the schema you designed, and see why the answers are only as good as the columns you gave it to reason about.
Why migrate at all, backed by ClickHouse's own published cost-performance benchmark rather than this workshop's sample dataset, then what changes between a one-off bucket load and a real pipeline, and where to send your own schema for a real answer.