The maximum number of partitions supported in a table is 2500. 2000 is the number of partitions we allow a single operation (in this case, a query job) to produce. We might consider increasing 2500 to a higher number in future, but have lesser freedom with the 2000 number.

We'll clarify the difference in the documentation. Thanks!

The maximum number of partitions supported in a table is 4000.
2000 is the number of partitions we allow a single operation (in this case, a query job) to produce.

Quotas & Limits - Partitioned tables

• Maximum number of partitions per partitioned table — 4,000

• Maximum number of partitions modified by a single job — 2,000

Each job operation (query or load) can affect a maximum of 2,000 partitions. Any query or load job that affects more than 2,000 partitions is rejected by Google BigQuery.

• Maximum number of partition modifications per day per table — 5,000 You are limited to a total of 5,000 partition modifications per day for a partitioned table. A partition can be modified by using an operation that appends to or overwrites data in the partition. Operations that modify partitions include: a load job, a query that writes results to a partition, or a DML statement (INSERT, DELETE, UPDATE, or MERGE) that modifies data in a partition.

More than one partition may be affected by a single job. For example, a DML statement can update data in multiple partitions (for both ingestion-time and partitioned tables). Query jobs and load jobs can also write to multiple partitions but only for partitioned tables. Google BigQuery uses the number of partitions affected by a job when determining how much of the quota the job consumes. Streaming inserts do not affect this quota.

• Maximum rate of partition operations — 50 partition operations every 10 seconds

The maximum number of partitions supported in a table is 2500. 2000 is the number of partitions we allow a single operation (in this case) to produce. We might consider increasing 2500 to a higher number in future, but have lesser freedom with the 2000 number.

We'll clarify the difference in the documentation. Thanks!

The maximum number of partitions supported in a table is 2500. 2000 is the number of partitions we allow a single operation (in this case, a query job) to produce. We might consider increasing 2500 to a higher number in future, but have lesser freedom with the 2000 number.

We'll clarify the difference in the documentation. Thanks!