The CHANGES change history function is now in preview. This table-valued function provides a history of table changes over a window of time and captures the following operations
Share
Services
## Feature
The [CHANGES change history function](https://cloud.google.com/bigquery/docs/reference/standard-sql/table-functions-built-in#changes) is now in [preview](https://cloud.google.com/products/#product-launch-stages). This table-valued function provides a history of table changes over a window of time and captures the following operations:
* [CREATE TABLE DDL statement](https://cloud.google.com/bigquery/docs/reference/standard-sql/data-definition-language#create%5Ftable%5Fstatement)
* [INSERT DML statement](https://cloud.google.com/bigquery/docs/reference/standard-sql/dml-syntax#insert%5Fstatement)
* [Data appended or changed as part of a MERGE DML statement](https://cloud.google.com/bigquery/docs/reference/standard-sql/dml-syntax#merge%5Fstatement)
* [UPDATE DML statement](https://cloud.google.com/bigquery/docs/reference/standard-sql/dml-syntax#update%5Fstatement)
* [DELETE DML statement](https://cloud.google.com/bigquery/docs/reference/standard-sql/dml-syntax#delete%5Fstatement)
* [Loading data](https://cloud.google.com/bigquery/docs/loading-data) into BigQuery
* [Streaming ingestion](https://cloud.google.com/bigquery/docs/write-api#use%5Fdata%5Fmanipulation%5Flanguage%5Fdml%5Fwith%5Frecently%5Fstreamed%5Fdata)
* [TRUNCATE TABLE DML statement](https://cloud.google.com/bigquery/docs/reference/standard-sql/dml-syntax#truncate%5Ftable%5Fstatement)
* [Jobs](https://cloud.google.com/bigquery/docs/reference/rest/v2/Job) configured with a `writeDisposition` of `WRITE_TRUNCATE`
* Individual [table partition deletions](https://cloud.google.com/bigquery/docs/managing-partitioned-tables#delete%5Fa%5Fpartition)
## Feature
You can use data manipulation language (DML) to [modify rows that have been recently written to a BigQuery table](https://cloud.google.com/bigquery/docs/write-api#use%5Fdata%5Fmanipulation%5Flanguage%5Fdml%5Fwith%5Frecently%5Fstreamed%5Fdata) by the Storage Write API. This is now [generally available](https://cloud.google.com/products/#product-launch-stages) (GA).
## Feature
The BigQuery [continuous queries](https://cloud.google.com/bigquery/docs/continuous-queries-introduction) feature is now in [preview](https://cloud.google.com/products/#product-launch-stages).
Continuous queries let you build long-lived, continuously processing SQL statements that can analyze, process, and perform machine learning (ML) inference on incoming data in BigQuery in real time. You can configure continuous queries to replicate query results to a Pub/Sub topic, Bigtable instance, or another BigQuery table, a process also known as Reverse ETL.
You can use continuous queries to perform the following tasks, using the accessible language of SQL:
* Transform incoming data and act immediately on insights.
* Use Vertex AI to apply real time ML insights.
* Build automated event-driven data pipelines.
* Replicate real-time events to downstream operational systems like Bigtable.
To try BigQuery continuous queries, see [Create continuous queries](https://cloud.google.com/bigquery/docs/continuous-queries).
## Feature
You can now use BigQuery Omni Virtual Private Cloud (VPC) allowlists to restrict access to [AWS S3 buckets](https://cloud.google.com/bigquery/docs/omni-aws-create-external-table#allow-vpc) and [Azure Blob Storage](https://cloud.google.com/bigquery/docs/omni-azure-create-external-table#allow-vpc) from specific BigQuery Omni VPCs. This feature is in [preview](https://cloud.google.com/products#product-launch-stages).