title: BigQuery max partitions topping out at 2000 instead of 2500
body: <p>According to the <a href="https://cloud.google.com/bigquery/quotas#partitioned_tables" rel="nofollow noreferrer">BigQuery docs</a>, partitioned tables can have 2500 partitions:</p>
  
  <blockquote>
    <p>Maximum number of partitions per partitioned table — 2,500</p>
  </blockquote>
  
  <p>Yet:</p>
  
  <pre><code>$ bq query --destination_table grey-sort-challenge:partitioning_magic.nyc_taxi_trips_partitioned --time_partitioning_field pickup_datetime --use_legacy_sql=false "select * from \`grey-sort-challenge.partitioning_magic.nyc_taxi_trips\`"
  </code></pre>
  
  <blockquote>
    <p>Error in query string: Error processing job 'grey-sort-challenge:bqjob_r37b076ef0d3c4338_000001626c539e6a_1': Too many partitions produced by query, allowed 2000, query produces at least 2372 partitions</p>
  </blockquote>
  
  <p>Is it 2000, or 2500?</p>