•  Part I: Introduction to Google BigQuery connectors
  •  Google BigQuery connectors overview
  •  Connector comparison
    •  Mapping functionality
    •  Source functionality
    •  Target functionality
  •  Task examples
    •  Synchronization task use case
    •  Mapping and mapping task use case
    •  Mapping task with Oracle CDC sources use case
    •  Mapping in advanced mode use case
•  Part II: Data Integration with Google BigQuery V2 Connector
  •  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
      •  Related links
    •  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
      •  Partitioning
    •  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
    •  Hierarchy Parser transformation in mappings
    •  Hierarchy Builder transformation in mappings
    •  Assign a label to the transformations
    •  Rules and guidelines for mapping and mapping tasks
    •  Rules and guidelines for mappings in advanced mode
    •  Troubleshooting a mapping task
    •  Troubleshooting a mapping in advanced mode
  •  Migrating a mapping
    •  Use the same object path for the migrated mapping
    •  Use a different object path for the migrated mapping
      •  Migration options
    •  Rules and guidelines for migrating a mapping
  •  Upgrading to Google BigQuery V2 Connector
    •  Connection switching example
    •  Advanced properties retained after the switch
    •  Rules and guidelines
  •  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
•  Part III: Data Integration with Google BigQuery Connector
  •  Introduction to Google BigQuery Connector
    •  Data Integration Hosted Agent
    •  Google BigQuery Connector assets
    •  Google BigQuery example
    •  Administration of Google BigQuery Connector
  •  Google BigQuery connections
    •  Connection modes
      •  Connection mode example
      •  Rules and guidelines for Google BigQuery connection modes
    •  Google BigQuery connection properties
    •  Configuring the proxy settings on Windows
    •  Configuring the proxy settings on Linux
  •  Synchronization Tasks with Google BigQuery Connector
    •  Pre SQL and post SQL commands
    •  Google BigQuery sources in synchronization tasks
    •  Read modes
    •  Advanced Properties for Google BigQuery sources
    •  Data filters
      •  Simple Data Filters
      •  Advanced Data Filters
    •  Google BigQuery targets in synchronization tasks
    •  Write modes
    •  Advanced synchronization task options for Google BigQuery targets
    •  Advanced properties for Google BigQuery targets
    •  Upsert task operation
  •  Mappings and mapping tasks with Google BigQuery
    •  Pre SQL and post SQL commands
    •  Google BigQuery sources in mappings
    •  Google BigQuery targets in mappings
    •  Upsert task operation
    •  Partitioning
      •  Key range partitioning
    •  Hierarchy Parser transformation in mappings
    •  Hierarchy Builder transformation in mappings
    •  Rules and Guidelines for mappings and mapping tasks
  •  Data type reference
    •  Google BigQuery and transformation data types

Part I: Introduction to Google BigQuery connectors

Google BigQuery 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

EA_GBQ_CONN