Getting error while querying to get tables partition metadata in bigquery

userhU1j1 0
Viewed 60

BigQuery project has one dataset and around 1005 tables.I am running query to get partition metadata for tables.

Query is SELECT count(*) FROM bq-tf-test-500-298.unravelFr8ks4.INFORMATION_SCHEMA.PARTITIONS;

Following error getting INFORMATION_SCHEMA.PARTITIONS query attempted to read too many tables. Please add more restrictive filters Attaching Query screenshot

google-bigquery
1 Answers

Partitions view is currently at Preview state at the moment. It is possible that the tables it can read are limited. As the message suggests, a workaround of adding more filters could run your query.

Nestor Ceniza Jr0
Related