You must configure a Google BigQuery V2 connection with simple or hybrid mode when you enable
SQL ELT optimization
in a mapping task.
If you configure a Google BigQuery V2 connection with complex mode, the Secure Agent logs an
SQL ELT optimization
validation error in the session logs file and the mappings run in the Informatica runtime environment without full
SQL ELT optimization
.
When you configure
SQL ELT optimization
, the mappings support the following advance properties for a Google BigQuery V2 source:
Source type - Single, Query, Multiple Objects, and Parameter
Query options - Filter. Supports both simple and advanced filter conditions. You can use both the source filter in conjunction with the Filter transformation in the mapping.
Source Dataset ID
Source Table Name
Number of Rows to Read
Job Poll Interval In Seconds
Pre SQL using standard SQL query
Pre SQL Configuration
Post SQL using standard SQL query
Post SQL Configuration
SQL Override Query using standard SQL query
Billing Project ID
When you configure
SQL ELT optimization
, the mappings support the following advance properties for a Google BigQuery V2 connected and unconnected lookup:
Source type - Single
Source type - Query
Source type - Standard and materialized views
Source Object Type - Parameter
Source Dataset ID
Source Table Name
Job Poll Interval In Seconds
Pre SQL using standard SQL query
Pre SQL Configuration
Post SQL using standard SQL query
Post SQL Configuration
SQL Override Query using standard SQL query
Billing Project ID
When you configure
SQL ELT optimization
, the mappings support the following properties for an Google BigQuery V2 target:
Target Object Type - Single, Parameter
Operation
Insert
Update
Upsert
Delete
Data Driven
You can implement the Update Strategy through target operations.
Data Driven Condition
Target Dataset ID
Target Table Name
Update Mode
Enable Merge
Create Disposition for Insert operation. Supports only
Create if never
option.
Write Disposition for Insert operation. Supports only
Write append
option.
Write Mode. Use Bulk mode to push data into Google BigQuery.
Truncate target table
Job Poll Interval In Seconds
Pre SQL using standard SQL query
Pre SQL Configuration
Post SQL using standard SQL query
Post SQL Configuration
Billing Project ID
If you configure target advanced properties that are not supported, the Secure Agent logs an validation error in the session logs and the mappings run in the Informatica runtime environment without full