Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

Required fields*

5
  • 2
    That's too restrictive though. Imagine I have a standard table with 10 years worth of data and I want to partition it! With these limits I'd have to split it into two tables of 5 years. Commented Mar 28, 2018 at 21:41
  • Is there any workaround to this that doesn't involve slicing and dicing the original table? Commented Mar 29, 2018 at 11:17
  • The 2500 limit on a single table is something we are actively looking to increase across the board. At present, we are doing it on an as needed basis and are happy to do it for your project if you can provide us the project number. Commented Mar 29, 2018 at 22:35
  • Today this has been increased to 4000. cloud.google.com/bigquery/quotas#partitioned_tables Commented May 7, 2018 at 17:34
  • See the following question to see how to get around this limit by partitioning by week/month/year: stackoverflow.com/a/56125049/132438 Commented May 14, 2019 at 8:06