Maintained with ☕️ by
IcePanel logo

BigQuery - June 20th, 2023 [Feature]

Share

Services

## Feature [Metadata caching](https://cloud.google.com/bigquery/docs/metadata-caching) is now [generally available](https://cloud.google.com/products/#product-launch-stages) (GA). Using cached metadata might improve query performance for [BigLake tables](https://cloud.google.com/bigquery/docs/biglake-intro) and [object tables](https://cloud.google.com/bigquery/docs/object-table-introduction) that reference large numbers of objects, by allowing the query to avoid listing objects from Cloud Storage. This release includes support for the following new features: * [Protecting metadata cache data with customer-managed encryption keys](https://cloud.google.com/bigquery/docs/metadata-caching#use%5Fcustomer-managed%5Fencryption%5Fkeys%5Fwith%5Fcached%5Fmetadata). * [Statistics on metadata cache usage](https://cloud.google.com/bigquery/docs/metadata-caching#get%5Finformation%5Fon%5Fmetadata%5Fcache%5Fusage%5Fby%5Fquery%5Fjobs). * [Table statistics](https://cloud.google.com/bigquery/docs/metadata-caching#table%5Fstatistics) for better query plan performance. Metadata cache usage is billed going forward. For more information, see [Costs](https://cloud.google.com/bigquery/docs/biglake-intro#costs). ## Feature BigQuery now supports [querying Apache Iceberg tables](https://cloud.google.com/bigquery/docs/iceberg-tables) that are created by open source engines. This feature is now [generally available](https://cloud.google.com/products/#product-launch-stages) (GA).