Google BigQuery Connectors > Part II: Data Integration with Google BigQuery V2 Connector > Google BigQuery pushdown optimization > Pushdown optimization scenarios
  

Pushdown optimization scenarios

You can configure pushdown optimization using the Google BigQuery V2 Connector or the Google BigQuery ODBC Connector in mappings.

Google BigQuery V2 Connector

Important: To configure pushdown optimization using the Google BigQuery V2 Connector, verify that your organization has the Mappings-Advanced Pushdown Optimization license. To get the license, contact Global Customer Support.
You can use configure pushdown optimization for the following scenarios when you use Google BigQuery V2 Connector in mappings:
Source and target endpoints
Supported pushdown scenarios in mappings
Pushdown optimization type
Google BigQuery source
Google BigQuery target
Reads from and writes to Google BigQuery using the Google BigQuery V2 connection.
Full
Note: The Secure Agent pushes the entire mapping logic for processing to Google BigQuery.
Google Cloud Storage source
Google BigQuery target
Reads from Google Cloud Storage using a Google Cloud Storage V2 connection and writes to Google BigQuery using a Google BigQuery V2 connection.
Full
Note: You can use the Secure Agent or the Hosted Agent to run mappings enabled with pushdown optimization.

ODBC Connector

Important: Informatica recommends that you use the Google BigQuery V2 connection in mappings to configure pushdown optimization. If you cannot push down specific transformation logic using the Google BigQuery V2 connection, you can explore configuring pushdown optimization using the Google BigQuery ODBC connection.
You can configure pushdown for a mapping that uses a Google BigQuery ODBC connection to read from and write to Google BigQuery.
Source and target endpoints
Supported pushdown scenarios in mappings
Pushdown optimization type
Google BigQuery source
Google BigQuery target
Reads from and writes to Google BigQuery using the Google BigQuery ODBC connection with the Google BigQuery ODBC subtype.
The Google BigQuery ODBC connection uses the Google BigQuery ODBC 64-bit drivers on Windows and Linux systems. You must configure the Google BigQuery driver based on your system requirement.
Full, Source
Note: You can use the Secure Agent to run mappings enabled with pushdown optimization.
Note: You cannot configure pushdown optimization for a mapping task that is based on an elastic mapping.