Google BigQuery Connectors > Part I: Introduction to Google BigQuery connectors > Connector comparison > Mapping functionality
  

Mapping functionality

The following table compares the mapping functionality supported by Google BigQuery connectors:
Mapping functionality
Google BigQuery Connector
Google BigQuery V2 Connector
Hosted agent
Yes
Yes
Proxy server
Yes
Yes
Synchronization task
Yes
No
Mapping task
Yes
Yes (Preferred)
Elastic mappings
No
Yes
Dynamic mapping task
No
Yes
Data transfer task
No
Yes
Write CDC data to Google BigQuery Targets
No
Yes
Pushdown optimization
Use an ODBC connection with ODBC Subtype=Google BigQuery to enable source or full pushdown optimization between Google BigQuery source and target.
  • - Use a Google Cloud Storage V2 source connection and an Google BigQuery V2 target connection to enable full pushdown optimization between Google Cloud Storage source and Google BigQuery target.
  • - Use an ODBC connection with ODBC Subtype=Google BigQuery to pushdown optimization between Google BigQuery source and target.
Note: Pushdown optimization does not apply to elastic mappings.
Lookup transformation
No
Cache, uncached, connected, and unconnected
Note: Uncached lookups, Unconnected with cached lookups, and dynamic lookup cache do not apply to elastic mappings.
SQL transformation
No
Yes
Note: SQL transformation does not apply to elastic mappings.