Maintained with ☕️ by
IcePanel logo

BigQuery - April 16th, 2020 [Change, Feature]

Share

Services

## Feature [BigQuery Reservations](https://cloud.google.com/bigquery/docs/reservations-intro) is now [Generally Available (GA)](https://cloud.google.com/products/?hl=EN#product-launch-stages). BigQuery Reservations allows you to purchase BigQuery [slots](https://cloud.google.com/bigquery/docs/slots) to take advantage of BigQuery [flat-rate pricing](https://cloud.google.com/bigquery/pricing#flat%5Frate%5Fpricing) and allocate slots for workload management. ## Change Around the end of April 2020, [INFORMATION\_SCHEMA (Beta) views for dataset metadata](https://cloud.google.com/bigquery/docs/information-schema-datasets) will return metadata about all datasets in a region. Currently, these views return metadata about all datasets in the project across all regions. This upcoming change will also provide support for querying a specific region's metadata (for example, `region-us.INFORMATION_SCHEMA.SCHEMATA` instead of `INFORMATION_SCHEMA.SCHEMATA`). You can replicate this future behavior now by filtering on the `SCHEMATA` view's `LOCATION` column (for example, `LOCATION = 'US'`).