CODEWITHSUNDEEP
google-bigquery
user1958699
user1958699

Reputation: 91

Is there a limit to the number of tables allowed in bigquery

Is there a limit to the number of tables I can have in BigQuery? I'm trying to create multiple small tables to reduce query costs. Thanks!

Upvotes: 9

Views: 6095

Answers (4)

Doosik Bae
Doosik Bae

Reputation: 81

You can see this document. There is no maximum number of standard tables. but partitioned table have limit. (4,000) and if there are so many tables, api can be slow and have limitation to see table on console. When you use an API call, enumeration performance slows as you approach 50,000 tables in a dataset. The Cloud Console can display up to 50,000 tables for each dataset.

Upvotes: 0

Afanasii Kurakin
Afanasii Kurakin

Reputation: 3469

Now it's:

Maximum number of tables referenced per query — 1,000
Maximum unresolved legacy SQL query length — 256 KB
Maximum unresolved standard SQL query length — 1 MB
Maximum resolved legacy and standard SQL query length — 12 MB

https://cloud.google.com/bigquery/quotas

Upvotes: 6

Vukasin Toroman
Vukasin Toroman

Reputation: 636

There is no limit to the number of tables. You might have problems querying them all since there is a 10k limit to the length of a query string.

Upvotes: 6

Jordan Tigani
Jordan Tigani

Reputation: 26637

There is no limit in number of tables you can create. If you have more than a few thousand tables, listing a dataset may be slow (and opening the UI might be slow), but otherwise you can create as many tables as you need.

Upvotes: 4

Related Questions