Introduction to Google BigQuery V2 Connector
Google BigQuery V2 Connector assets
Google BigQuery example
Administration of Google BigQuery V2 Connector
Google BigQuery V2 connections
Connect to Google BigQuery
Before you begin
Connection details
Authentication type
Proxy server settings
Configure proxy settings for NTLM authentication
Mappings for Google BigQuery V2
Google BigQuery Storage API
Mappings with different connection modes
Rules and guidelines for Google BigQuery V2 connection modes
Google BigQuery V2 sources in mappings
Read modes
Custom query source type
Adding multiple source objects
Google BigQuery V2 targets in mappings
Write modes
Mapping tasks with CDC sources
Upsert task operation
Data driven operation for mappings
Using Merge query for update, upsert, and delete operations
Determine the order of processing for multiple targets
Clustering order
Stop on errors
Google BigQuery V2 lookups in mappings
Unconnected lookup transformation
Configuring an unconnected lookup transformation
Enabling lookup caching
Optimize lookup performance in staging mode
Setting default column value for the lookup and output ports
Rules and guidelines for Lookup transformation
Process SQL queries using an SQL transformation
Configuring an SQL transformation
Using a parameterized connection in an SQL transformation
Rules and guidelines for SQL transformation
Pre-SQL and post-SQL commands
Data filters
Handling dynamic schemas
Rules and guidelines for dynamic schema handling
Configure unique staging object names for concurrent mappings
Assign a label to the transformations
Rules and guidelines for mapping and mapping tasks
Troubleshooting a mapping task
SQL ELT with Google BigQuery V2 Connector
SQL ELT configuration options
SQL ELT query preview
Mappings in SQL ELT mode for Google BigQuery
Sources in mappings in SQL ELT mode
Targets in mappings in SQL ELT mode
Transformations in mappings in SQL ELT mode
Functions in mappings in SQL ELT mode
Operators in mappings in SQL ELT mode
Rules and guidelines in mappings in SQL ELT mode
SQL ELT optimization for mapping tasks
SQL ELT optimization
SQL ELT optimization using a Google BigQuery V2 connection
Read from and write to Google BigQuery
Read from Google Cloud Storage and write to Google BigQuery
Read from Amazon S3 and write to Google BigQuery
Rules and guidelines for SQL ELT optimization
Troubleshooting a SQL ELT optimization task
Data type reference
Google BigQuery V2 and transformation data types
Introduction to Google BigQuery V2 Connector
Google BigQuery V2 and transformation data types
EA_GBQV2_CONN
EA_GBQV2_CONN-CONN_NAME
EA_GBQV2_CONN-CONN_DESC
EA_GBQV2_CONN-CONN_TYPE
EA_GBQV2_CONN-AGENTGROUPID
EA_GBQV2_CONN-AUTHENTICATION
EA_GBQV2_CONN-AUTHENTICATION-SERVICE_ACCOUNT
EA_GBQV2_CONN-CLIENTEMAIL
EA_GBQV2_CONN-SERVICE_ACCOUNT-CLIENTEMAIL
EA_GBQV2_CONN-PRIVATEKEY
EA_GBQV2_CONN-SERVICE_ACCOUNT-PRIVATEKEY
EA_GBQV2_CONN-PROJECTID
EA_GBQV2_CONN-ENABLESTORAGEAPI
EA_GBQV2_CONN-SERVICE_ACCOUNT-ENABLESTORAGEAPI
EA_GBQV2_CONN-SERVICE_ACCOUNT-ENABLESTORAGEAPI-FALSE
EA_GBQV2_CONN-SERVICE_ACCOUNT-ENABLESTORAGEAPI-TRUE
EA_GBQV2_CONN-SERVICE_ACCOUNT-STORAGEPATH
EA_GBQV2_CONN-SERVICE_ACCOUNT-FALSE-STORAGEPATH
EA_GBQV2_CONN-SERVICE_ACCOUNT-CONNECTORTYPE
EA_GBQV2_CONN-SERVICE_ACCOUNT-FALSE-CONNECTORTYPE
EA_GBQV2_CONN-SERVICE_ACCOUNT-USELEGACYSQLFORCUSTOMQUERY
EA_GBQV2_CONN-SERVICE_ACCOUNT-FALSE-USELEGACYSQLFORCUSTOMQUERY
EA_GBQV2_CONN-DATASETNAMEFORCUSTOMQUERY
EA_GBQV2_CONN-SERVICE_ACCOUNT-SCHEMALOCATION
EA_GBQV2_CONN-SERVICE_ACCOUNT-FALSE-SCHEMALOCATION
EA_GBQV2_CONN-REGIONID
EA_GBQV2_CONN-SERVICE_ACCOUNT-DATASETNAMEVALUE
EA_GBQV2_CONN-SERVICE_ACCOUNT-FALSE-DATASETNAMEVALUE
EA_GBQV2_CONN-PROVIDEOPTIONALPROPERTIES
EA_GBQV2_CONN-ENABLERETRY
EA_GBQV2_CONN-ENABLERETRY-TRUE
EA_GBQV2_CONN-ENABLERETRY-FALSE
EA_GBQV2_CONN-TRUE-MAXRETRYATTEMPTS
EA_GBQV2_CONN-TRUE-INITIALRETRYDELAY
EA_GBQV2_CONN-TRUE-RETRYDELAYMULTIPLIER
EA_GBQV2_CONN-TRUE-MAXRETRYDELAY
EA_GBQV2_CONN-TRUE-TOTALTIMEOUT
CDI_GBQV2_CONFIGURE_PROXY_SETTINGS