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 Google BigQuery V2 Connector for SQL ELT optimization. | You can use an Amazon S3 V2, Google BigQuery V2, or Google Cloud Storage V2 source connection and a Google BigQuery V2 target connection to enable full SQL ELT optimization. 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. |