How to merge Big Query table lists?

Question

I saved it in Big Query using Firebase Analytics.

I want SELECTevents stored in a large request. But the tables are by date.

Are there any events SELECTin these tables at the same time?

Answer 1

Tick Wildcard Tablesfunction

Quick example:

#standardSQL
SELECT *
FROM `project.dataset.app_events_*`