BigQuery

noun · data warehouse · element 117 of 117

Google Cloud's serverless data warehouse. It runs SQL over very large tables, and GA4 can export its raw event data into it.

My levelProficientComfortable in production. I ship with it without supervision.
Family
Search and visibility

What is BigQuery?

BigQuery stores data in tables and answers SQL queries over billions of rows in seconds, with no servers to manage: you pay for storage and for the data each query reads.

GA4 can export every raw event to BigQuery, daily or as a stream, which answers the questions the standard GA4 reports cannot.

How I use BigQuery

I use BigQuery with the GA4 export, when a question needs the raw events rather than a standard report.

Projects with BigQuery

None of the projects on this site are tagged BigQuery yet. The closest work is my GA4 projects.