Reply To: GA4 events_ in BigQuery fragmented into multiple tables

[Olivia]

It sounds like it could be a sharding issue. Google BigQuery automatically creates a new shard (or table) each day for GA4 data, and this might be why you’re seeing the data split into separate tables. To view all your data as one singular table, you should use a wildcard to query across all the “events_” tables. It should look something like this: “SELECT * FROM project.dataset.events_*“. This query will fetch the data from all the physical tables starting with “events_”. Essentially, it should unite all your sharded tables during the query itself.