https://www.growthbook.io/ logo
c

creamy-sugar-16875

09/01/2023, 5:26 PM
In case Jeremey isn't available and there's some one else that may be able to provide their input
f

fresh-football-47124

09/01/2023, 8:38 PM
Hi Nathan
Those date partitions depend on how you’re storing data - are you using the incremental/interday tables?
c

creamy-sugar-16875

09/01/2023, 8:50 PM
Thanks Graham the line
Copy code
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.