many-wall-58468
04/26/2023, 2:22 PMevents_
tables in the experiment queries to events_intraday_
, but not sure if that’s possible.fresh-football-47124
many-wall-58468
04/26/2023, 3:58 PMevents_*
in the queries was indeed already pulling in the intraday data since those tables match that wildcard too, but then they were filtered out with the
_TABLE_SUFFIX BETWEEN '{{startYear}}{{startMonth}}{{startDay}}' AND '{{endYear}}{{endMonth}}{{endDay}}'
I replaced that with:
REGEXP_EXTRACT(_TABLE_SUFFIX, r'[0-9]+') BETWEEN '{{startYear}}{{startMonth}}{{startDay}}' AND '{{endYear}}{{endMonth}}{{endDay}}'
And it now includes all data from both daily events & intraday events tables.fresh-football-47124
many-wall-58468
04/28/2023, 5:24 PMfresh-football-47124