Open source platform for stress free deployments, measured impact, and smarter decisions.

GrowthBook Users

In case Jeremey isn't available and there's some one else that may be able to provide their input

Those date partitions depend on how you’re storing data - are you using the incremental/interday tables?

<https://linen.growthbook.io/t/10508969/when-using-ga4-data-through-bigquery-is-it-possible-to-inclu#9ee29993-99d6-4355-87a1-3139a2a2db43>

Thanks Graham the line
```REGEXP_EXTRACT(_TABLE_SUFFIX, r'[0-9]+') BETWEEN '{{startYear}}{{startMonth}}{{startDay}}' AND '{{endYear}}{{endMonth}}{{endDay}}'```
is working for me!

But to answer your question we have an `events_`  and an `events_intraday_`  table.