Preface
Introduction to PowerExchange for Google BigQuery
- PowerExchange for Google BigQuery Overview
- Introduction to Google BigQuery
PowerExchange for Google BigQuery Configuration
- PowerExchange for Google BigQuery Configuration Overview
- Prerequisites
Configuring HTTP Proxy Options
- Configuring HTTP Proxy Options for the Mercury Client
- Configuring HTTP Proxy Options for the Data Integration Service
Google BigQuery Connections
PowerExchange for Google BigQuery Data Objects
PowerExchange for Google BigQuery Mappings
- PowerExchange for Google BigQuery Mappings Overview
- Mapping Validation and Run-time Environments
Google BigQuery Lookup
Google BigQuery Run-Time Processing
Appendix A: Google BigQuery Data Type Reference
- Data Type Reference Overview
- Google BigQuery and Transformation Data Types

PowerExchange for Google BigQuery User Guide

10.5.6
- 10.5.9
- 10.5.8
- 10.5.7
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5
- 10.4.1
- 10.4.0

Back Next

Google BigQuery Data Object Write Operation

Create a mapping to write data to Google BigQuery. Use the Google BigQuery connection, and define the write operation properties to write data to Google BigQuery.

You can perform insert, update, delete, and upsert operations on a Google BigQuery target.

To perform a update, delete, or upsert operation, you must add an Update Strategy transformation to a mapping and flag the records in an update strategy expression.

When you run a mapping on the Spark engine, you cannot add an Update Strategy transformation. Hence, you cannot perform update, delete, or upsert operations on a Google BigQuery target when you run a mapping on the Spark engine.

For more information about configuring an Update Strategy transformation, see "Update Strategy Transformation" in the

Informatica Developer Transformation Guide

PowerExchange for Google BigQuery Data Objects

Input Properties of the Data Object Write Operation

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal