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

Question

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!

Answer 1

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

Answer 2

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.

Answer 3

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.