Table of Contents

Search

  1. Preface
  2. Part 1: Introduction to Google BigQuery connectors
  3. Part 2: Data Integration with Google BigQuery V2 Connector
  4. Part 3: Data Integration with Google BigQuery Connector

Google BigQuery Connectors

Google BigQuery Connectors

Mapping functionality

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

0 COMMENTS

We’d like to hear from you!