We recently switched from GA4 daily to streaming via BigQuery. It seems we need to update

events_*

to

events_intraday_*

in the queries. Is there an easier way to do that rather than go to each metric or wherever a query is created?

Hey Erik - unfortunately, we don't have any provisions for bulk updates like this at this time. Depending on how valuable your historical data is, I might suggest creating a new project, and then creating a completely new data source and associated metrics in that new project. This will allow you to retain historical data and easily differentiate between new features/experiments that use the streaming tables vs the legacy features/experiments that use the daily export tables. (All of this is assuming Google doesn't offer any trick services that port the old daily data to the new tables.)

Ok, thanks!

Hmm... I don't think the

OR

statement should cause problems, but won't there still be the issue of the

FROM

clause? I'm pretty sure standard SQL doesn't support the

OR

operator in the

FROM

clause.

That is what I got when I created a new metric after streaming from BigQuery was enabled.

Erik - I just spoke to a colleague and he mentioned that table format should be identical, it's just the table suffix that is different (it has

_intraday

added to the table name). Additionally, we did add support for this recently for any newly created metrics/data sources so it queries both tables at once. And it just does what you mentioned earlier, of updating the WHERE clause.

WHERE 
((_TABLE_SUFFIX BETWEEN '{{date startDateISO "yyyyMMdd"}}' AND '{{date endDateISO "yyyyMMdd"}}') OR
   (_TABLE_SUFFIX BETWEEN 'intraday_{{date startDateISO "yyyyMMdd"}}' AND 'intraday_{{date endDateISO "yyyyMMdd"}}'))

We don't have a way to bulk update metric SQL, so they will just have to go through each one and copy/paste this new WHERE clause in. We are working on our new

Fact Tables

and one of the goals of that is to have the common SQL in one place so it's easy to make sweeping changes like this.

Gotcha. Thanks for getting back to me so quick! Not a huge deal on editing the metrics. It also looks like we needed to edit the assignment queries as well. I did a quick test earlier before lunch and it all seems to jive now.

Hey Erik - yea, the WHERE clause pasted above can improve query performance to make sure we are only scanning relevant data and hopefully filtering based on some table you have partitioning set up on. It's possible depending on your setup that it doesn't improve performance, but for most out of the box GA4 integrations, it will improve performance.

Ok, awesome. Appreciate the quick response!