Data Integration Connectors
- Data Integration Connectors
- All Products
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 .SQL ELT optimization does not apply to mappings in advanced
mode. |
Lookup transformation | No | Cache, uncached, connected, and unconnected Uncached lookups, Unconnected with cached lookups, and dynamic
lookup cache do not apply to mappings in advanced mode. |
SQL transformation | No | Yes SQL transformation does not apply to mappings in advanced mode.
|