Bigquery how to query multiple tables of the same structure?

Question

I have datasets of the same structure and i know I can query them like this, they are named by date:

SELECT column
FROM [xx.ga_sessions_20141019] ,[xx.ga_sessions_20141020],[xx.ga_sessions_20141021] 
WHERE column = 'condition';

However I actually want to query various months of this data... so instead of listing them all in the same way as above, is there syntax that you can use that looks like:

SELECT column
FROM [xx.ga_sessions_201410*] ,[xx.ga_sessions_201411*]
WHERE column = 'condition';

possible duplicate of [Querying multiple tables in Big Query](http://stackoverflow.com/questions/13171776/querying-multiple-tables-in-big-query) — Ciro Santilli OurBigBook.com, Sep 08 '15 at 14:02

Danny Kitt · Accepted Answer · 2014-11-18T20:59:39.950

7

Take a look at the table wildcard functions section of the BigQuery query reference. TABLE_DATE_RANGE or TABLE_QUERY will work for you here. Something like:

SELECT column
FROM TABLE_DATE_RANGE(xx.ga_sessions_,
                      TIMESTAMP('2014-10-19'),
                      TIMESTAMP('2014-10-21'))
WHERE column = 'condition';

edited Nov 18 '14 at 20:59

answered Nov 18 '14 at 20:51

Danny Kitt

3,241
12
22

Bigquery how to query multiple tables of the same structure?

1 Answers1