Partitions lost during SQL-view (GA4 package)

Help
, ,
1

The problem I’m having

I’m using the GA4-package (Velir) in dbt to transform al the GA4-data in my BigQuery Warehouse. However, the view called ‘stg_ga4__events.sql’ seems unable to use the partitions that are available in the referenced table (base_ga4__events.sql).

Has anyone seen this before? And is there an (obvious) solution to this?

The context of why I’m trying to do this

Without this partitions in place, the query will generate over 1TB of processing, which is very costly.

What I’ve already tried

When filtering on date first thing in the view, the partitions do their job. It will then only process about 2gb of data. When applying the same filter on the final join however, BigQuery can’t find the partition and needs to scan the entire table (> 1 TB).

Some example code or error messages

-- top of the script
with base_events as (
    select * from {{ ref('base_ga4__events')}}
where event_date_dt = '2025-09-01' --it does use partitions here
),

-- bottom of the script
select * from page_key
where event_date_dt = '2025-09-01' --it does not recognize the partition here

Link to the package: dbt-ga4/models/staging/stg_ga4__events.sql at main · Velir/dbt-ga4 · GitHub