Project caps (also known as scheduling policies) let you limit maximum slots and concurrency per project within a BigQuery

## Feature Feature [Project caps (also known as scheduling policies)](https://cloud.google.com/bigquery/docs/reservations-workload-management#scheduling-policies)let you limit maximum slots and concurrency per project within a BigQuery reservation. This feature is only supported in the[BigQuery Enterprise and Enterprise Plus editions](https://cloud.google.com/bigquery/docs/editions-intro)and is[generally available](https://cloud.google.com/products#product-launch-stages)(GA). ## Feature Feature You can specify an optional `principal` property on[BigQuery reservation assignments](https://cloud.google.com/bigquery/docs/reservations-assignments) to route queries to specific reservations based on the identity of the user, service account, or third-party identity executing the job. This feature is only supported in the[BigQuery Enterprise and Enterprise Plus editions](https://cloud.google.com/bigquery/docs/editions-intro)and is[generally available](https://cloud.google.com/products#product-launch-stages)(GA). ## Feature Feature You can use the[JSON\_FLATTEN function](https://cloud.google.com/bigquery/docs/reference/standard-sql/json%5Ffunctions#json%5Fflatten)to extract all non-array values that are either directly in the input `JSON`value or children of one or more consecutively nested arrays in the input`JSON` value. This function is[generally available](https://cloud.google.com/products#product-launch-stages). (GA).