-
Generation of daily events_intraday_ tables but no creation of corresponding events_ tables in BigQuery
I’ve been using GA4 to BigQuery Streaming export for about a month because my daily events have exceeded the export limit (2.7 million events vs 1 million events).
In Google’s documents (https://support.google.com/firebase/answer/7029846?hl=en), it says:
If the Streaming export option is enabled, a table called events_intraday_YYYYMMDD is created. This table is continually filled with data throughout the day and is supposed to be deleted at the end of each day once the events_YYYYMMDD is complete.So, according to this, I thought I’d have
events_YYYYMMDDtables for each day in the past and aevents_intraday_YYYYMMDDtable for the current day. But that’s not what’s happening – I only haveevents_intraday_YYYYMMDDtables for past days.Am I misunderstanding the docs here? Should I be expecting the
events_YYYYMMDDtables to be automatically made and filled in?If it’s on me to make sure this happens, then do I need to start manually backing this up?
-
2 Replies
-
According to the documentation you’ve mentioned, an
events_YYYYMMDDtable should be created and filled in for each day, and anevents_intraday_YYYYMMDDtable for the current day should exists. Theevents_intraday_YYYYMMDDtable is filled continuously throughout the day and should be deleted when its correspondingevents_YYYYMMDDtable is complete. However, if you only seeevents_intraday_YYYYMMDDtables for past days, it seems like the process is not functioning as stated in the documentation. You might want to reach out to Google support for further assistance on this issue. You should not have to manually back this up according to the provided documentation. -
According to the documentation from Google, you should get an
events_YYYYMMDDtable for each past day and a current day’sevents_intraday_YYYYMMDDtable, which is filled throughout the day and then deleted once theevents_YYYYMMDDtable for the day is complete. If you’re only seeingevents_intraday_YYYYMMDDtables for past days and not theevents_YYYYMMDDtables, it seems like there may be an issue with your setup. It is not you who is responsible for creating theevents_YYYYMMDDtables; they should be made and populated automatically by Google. It is highly recommended that you get in touch with Google’s support to troubleshoot this problem. As for manual backup, you should not need to do this because the data is meant to be automatically migrated from theevents_intraday_YYYYMMDDto theevents_YYYYMMDDtable by the end of each day.
Log in to reply.