CODEWITHSUNDEEP
google-bigquery
foxwendy
foxwendy

Reputation: 2929

Bigquery console does not show all tables

We are now having 1144 tables in one dataset, but many of them are not listed in the left hand list of Bigquery console. I wonder if this is due to a set limit.

Upvotes: 13

Views: 5069

Answers (1)

Jordan Tigani
Jordan Tigani

Reputation: 26617

The BigQuery Web UI will only show 1000 tables in a dataset (likewise will show only 1000 projects and 1000 datasets in each project). I've filed a bug to either show a longer list or provide a way to load more in the UI.

In the meantime, however, you can use bq to list your tables:

$ bq ls --max_results=10000 your_dataset_name

Upvotes: 17

Related Questions