CODEWITHSUNDEEP
google-bigquery
Андрій Хамурда
Андрій Хамурда

Reputation: 55

Does 1000 tables per query limit apply to partitioned tables?

I know that this limit applies when I query 1000 different tables, but Firebase Analytics exports its events to single partitioned table named 'app_events_*'.

A new partition is automatically created each day. I will have 1000 partitions of this table if I track events for 2 years and 269-270 days.

It's not clear to me if I can use wildcard in my query and use more than 1000 partitions of same partitioned table (more than 1000 days of data).

What exactly happens in this scenario?

Thanks in advance.

Upvotes: 0

Views: 155

Answers (1)

Elliott Brossard
Elliott Brossard

Reputation: 33705

That's not a partitioned table. You can read about partitioned tables in the documentation. Wildcard tables, which are what you are using, let you query multiple tables at once, and the same 1000 tables per query limit applies as if you had unioned then explicitly in the query.

Upvotes: 3

Related Questions