CODEWITHSUNDEEP
google-bigquerygoogle-cloud-platform
Tim S
Tim S

Reputation: 185

Google BigQuery - Using wildcard table query with date partitioned table?

I am trying to use wildcard table functions to query bunch of date-partitioned tables.

This query works: 

select * from `Mydataset.fact_table_1` where _partitiontime='2016-09-30' limit 10

This query does not work:

select * from `Mydataset.fact_table_*` where _partitiontime='2016-09-30' limit 10

Is this operation not supported?

If it is not supported what's the best way to read same day's data from multiple date-partitioned tables?

Upvotes: 4

Views: 2258

Answers (1)

Royzipuff
Royzipuff

Reputation: 507

Following statement

select * from TABLE_QUERY(YOUR_DATASET,'table_id contains "fact_table_"') where _PARTITIONTIME = TIMESTAMP('2016-09-30')

Should do the trick

Upvotes: 1

Related Questions