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

Google BigQuery pushdown optimization overview

When you run a task configured for pushdown optimization, the task converts the transformation logic to an SQL query. The task sends the query to the database, and the database executes the query.
The amount of transformation logic that you can push to the database depends on the database, transformation logic, and task configuration. The task processes all transformation logic that it cannot push to the database.
You can use the following connections in mappings to configure full pushdown optimization for the described scenarios:
Connection type
Supported pushdown scenarios
Google BigQuery V2 connection
You can configure pushdown for the mappings that read from Google Cloud Storage using Google Cloud Storage V2 connection and write to Google BigQuery using the Google BigQuery V2 connection.
Important: To configure pushdown optimization, verify that your organization has the Mappings-Advanced Pushdown Optimization license. To get the license, contact Global Customer Support.
Note: You can use the Secure Agent or the Hosted Agent to run mappings enabled with pushdown optimization.
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.
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.
Note: You can use the Secure Agent to run mappings enabled with pushdown optimization.