Google BigQuery V2 Connector > Introduction to Google BigQuery V2 Connector

Introduction to Google BigQuery V2 Connector

You can use Google BigQuery V2 Connector to securely read data from or write data to Google BigQuery.

You can configure Google BigQuery V2 Connector to read data from the following Google BigQuery objects:

•Google BigQuery tables, standard and materialized views.
•BigLake Iceberg tables that are managed by Google BigQuery.

You can write data to the following Google BigQuery objects:

•Google BigQuery tables.
•BigLake Iceberg tables that are managed by Google BigQuery.

You can create a Google BigQuery V2 connection and use the connection in Data Integration mappings and tasks. When you run a task or mapping, the Secure Agent uses the JAVA client libraries of the Google APIs to integrate with Google BigQuery.

When you use Google BigQuery V2 Connector to create and run a Data Integration task, the Secure Agent reads from and writes data to Google BigQuery based on the taskflow and Google BigQuery V2 connection configuration.

You can move data from any data source to Google BigQuery.

Use Google BigQuery V2 Connector to create a mapping, data transfer task, or a mapping task.

If you enable cross-region replication in Google BigQuery for disaster recovery purposes, you can read from or write to datasets in these replicated regions.