Geek Answers Handbook

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

Is there a limit on the number of tables that I can have in BigQuery? I am trying to create several small tables to reduce query costs. Thanks!

+7
source share
3 answers

Now this:

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

+5
source

There are no restrictions on the number of tables. You may have problems querying them all, since there is a 10k limit on the length of the query string.

+4
source

There are no limits to the number of tables you can create. If you have more than a few thousand tables, the list of datasets can be slow (and opening the user interface can be slow), but otherwise you can create as many tables as you need.

+3
source

More articles:


All Articles