Maintained with ☕️ by
IcePanel logo

The following BigQuery cross-cloud features are now generally available

Share

Services

## Feature The following BigQuery cross-cloud features are now[generally available](https://cloud.google.com/products/#product-launch-stages)(GA): * You can take advantage of the benefits of[materialized views over Amazon S3 metadata cache-enabled BigLake tables](https://cloud.google.com/bigquery/docs/materialized-views-intro#biglake). * You can create[materialized view replicas](https://cloud.google.com/bigquery/docs/materialized-views-intro#materialized%5Fview%5Freplicas)of materialized views over Amazon S3 metadata cache-enabled Biglake tables. Materialized view replicas let you use the materialized view data in queries while avoiding data egress costs and improving query performance. * You can[get information about materialized view replicas](https://cloud.google.com/bigquery/docs/materialized-view-replicas-manage#get-info) by using SQL, the bq command-line tool, or the BigQuery API. * You can use [cross-cloud joins](https://cloud.google.com/bigquery/docs/biglake-intro#cross-cloud%5Fjoins) to run queries that span both Google Cloud and BigQuery Omni regions. ## Feature The consolidated SQL translator API combines the interactive and batch translator into a single workflow, improving the efficiency and stability of your [translation jobs created using the API](https://cloud.google.com/bigquery/docs/batch-sql-translator#api). This feature is available in [preview](https://cloud.google.com/products#product-launch-stages).