0

I've been running the GA4 to BigQuery Streaming export for over a month now because the amount of daily events is bigger than the daily export limit (currently around 1.5 million events per day).

Google docs (https://support.google.com/analytics/answer/7029846#tables): If the Streaming export option is enabled, a table named events_intraday_YYYYMMDD is created. This table is populated continuously as events are recorded throughout the day. This table is deleted at the end of each day once events_YYYYMMDD is complete.

According to the docs I should have events_YYYYMMDD tables for previous days and events_intraday_YYYYMMDD table for current day. But that's not the case - all I'm stuck with are events_intraday_YYYYMMDD tables for previous days.

This is the same issue reported in the following posts (I actually copied and pasted from the first post):

BigQuery events_intraday_ tables are being generated daily but no daily events_ table is created

Firebase Analytics doesn't export events table to Bigquery, even though streaming export is enabled

GA4 exports only intraday tables to BigQuery

Unfortunately, none of these posts have a solution and I don't yet have enough reputation here on SO to post a comment to them. I'm currently not paying for Google support because I'm still evaluating GA4, so I’m hoping someone here can provide an answer (and maybe then I can share it with the other's that had the same problem).

rtdewi0111
  • 1
  • 2

1 Answers1

0

The events table is only created and populated when you select the daily option. If you also have the streaming option the streaming data is copied to the events tables throughout the day and then the next day the previous day is loaded into the events table and essentially "topped up". The streaming tables should be static as long as you have a billing account set up and have changed the expiration on the tables and the data set itself.

This article goes through how to change the expiration on multiple tables at once.

Jared
  • 48
  • 1
  • 12