Clever Geek Handbook

Any way to overcome the BigQuery 1000 table limit?

It looks like 1000 tables limit and we have to start dropping old tables.

Can we get an increase anyway?

+3


source to share


1 answer


There is currently no hard constraint on tables in the dataset. They definitely have over 1000 tables. You may be having trouble getting a complete list.



  • If you are using the API directly to display tables, you will need to view the results with nextPageToken if you have more than 1000 tables in your dataset.
  • If you are using bq you can list over 1000 tables by running bq ls -n 2000 <DATASET_ID>

    to list 2000 tables for example.
  • Our web interface will display up to 10,000 tables in a dataset.
+5


source






More articles:


All Articles