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 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.
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.
|