BigQuery project caps and reservation assignment principal are generally available

Project caps (also known as 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 and is generally available (GA).

You can specify an optional principal property on BigQuery reservation 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 and is generally available (GA).

You can use the JSON_FLATTEN function 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. (GA).