GA to GBQ data streaming timing?

Question

I am asking this question as I didn't receive reply on Google Forum nor from the GCP Support team.

I have linked the product Google BigQuery (GBQ) to the Google Analytics (GA) for a view ID, which is fetching all the data from GA to GBQ dataset under two views in respective tables as :

I have two questions on Intraday Views:

1. Why current day table is not populated in GBQ? Even GBQ doesn't support Real time data from GA, at least they should provide delayed data within a buffer of some hours.

2. Does GBQ have a fixed timing to update the Intraday table trice in a day?

How can I tackle these scenarios?

Answer 1

ad Q1: There is real-time streaming for GA export: https://support.google.com/analytics/answer/7430726?hl=en&ref_topic=3416089

ad Q2: From my experience, this varies - you can monitor both:

• table creation using meta-tables: https://cloud.google.com/bigquery/docs/datasets#tables-meta-table
• export logs (which should be filtered for protopayload_auditlog.authenticationInfo.principalEmail = "analytics-processing-dev@system.gserviceaccount.com") to BigQuery and analyze them: https://cloud.google.com/logging/docs/export/