Google BigQuery Connectors

Back Next

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