BigQuery SQL & GA4: How to Query Multiple Tables Using _TABLE_SUFFIX
Select From All Tables Select From Specific Dates Select Only Yesterday’s Data Note: sometimes yesterday’s data may not always be fully exported yet from GA4 and loaded into your raw table. So you can do a “2 day delay load” by selecting only the data from 2 days ago: Select Data From 2 Days Ago