Data Warehouse
BigQuery
Serverless data warehouse for marketing data. EU region as default, native GA4 binding, cheaper than Snowflake for analytical workloads under 1 TB/month.
BigQuery vs Snowflake for marketing
For marketing-analytics workloads under 1 TB/month, BigQuery is simply cheaper. Snowflake bills compute minutes, BigQuery bills bytes. The GA4 raw export lands directly in BigQuery (no middleman), and Google Ads / Search Ads 360 have native connectors. For a marketing stack, that saves 2–3 integrations.
Snowflake becomes the better choice at mixed enterprise workloads (analytics + app data + ML features) where multi-cloud or cross-region sharing matters.
EU region, not optional
BigQuery datasets must be created explicitly in europe-west1 (Belgium) or europe-west3 (Frankfurt). The default is US, and GA4 exports automatically write to the dataset's region. Miss this and you unintentionally land on US cloud, in doubt, in violation of your own privacy policy.
Our BigQuery setup
- Ingest: GA4 raw export, Google Ads, Funnel.io (for Meta/TikTok/LinkedIn), Stape event logs
- Modelling: dbt Core, CI via GitHub Actions
- Governance: row-level security, separate datasets per use case, BigQuery admin dashboard
- Cost control: date partitioning, slot reservations from ~€2k/month spend
- BI layer: Data Studio (free) or Looker (enterprise) depending on governance requirements
Topical context
- BigQuery GA4 export
- BigQuery EU region
- marketing data warehouse
- BigQuery cost
- dbt BigQuery
-
Is the GA4 export to BigQuery GDPR-compliant?
Yes, if the BigQuery dataset sits in an EU region (europe-west1 Belgium or europe-west3 Frankfurt) and the Google DPA is signed. By default the dataset is created in the US, that has to be changed actively. Without an EU region and DPA there's no clean GDPR path.
-
What does BigQuery cost for a typical marketing stack?
For GA4 export plus ad data at medium volume (10–50 M events/month): €50–€300 per month. Storage is ~€0.02/GB, queries €5/TB. With partitioning and slot reservations from ~€2,000/month spend, the cost stabilises, before reservations, budget discipline matters.
-
Can BigQuery connect directly to Looker, Power BI, or Tableau?
Yes, all three have native BigQuery connectors. Looker Studio is free and the default entry point for GA4 data. Power BI and Tableau need a service account, and at high data volume slot reservations to prevent dashboards from becoming query-cost drivers.