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) |
Dynamic mapping task | No | Yes |
Data transfer task | No | Yes |
Write CDC data to Google BigQuery Targets | No | Yes |
SQL ELT optimization | Use an ODBC connection with ODBC Subtype=Google BigQuery to enable source or full SQL ELT 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 SQL ELT optimization between Google Cloud Storage source and Google BigQuery target. Note: SQL ELT optimization does not apply to mappings in advanced mode. |
Lookup transformation | No | Cache, uncached, connected, and unconnected Note: Uncached lookups, Unconnected with cached lookups, and dynamic lookup cache do not apply to mappings in advanced mode. |
SQL transformation | No | Yes Note: SQL transformation does not apply to mappings in advanced mode. |