Google BigQuery Connectors > Part II: Data Integration with Google BigQuery V2 Connector > Upgrading to Google BigQuery V2 Connector > Advanced properties retained after the switch
  

Advanced properties retained after the switch

The following table lists the configured advanced source and target properties from Google BigQuery ODBC that are retained in Google BigQuery V2 mappings:
Properties
Google BigQuery ODBC properties retained in Google BigQuery V2
Source
  • - Pre SQL
  • - Post SQL
  • - SQL Override
Target
  • - Pre SQL
  • - Post SQL
  • - Update Override
The following table lists the configured advanced source, lookup, and target properties from Google BigQuery V1 mappings that are retained in Google BigQuery V2 mappings:
Properties
Google BigQuery V1 properties retained in Google BigQuery V2
Source and Lookup
  • - Source Dataset ID
  • - Source Table Name
  • - Number of Rows to Read
  • - Allow Large Results
  • - Query Results Table Name
  • - Job Poll Interval In Seconds
  • - Read Mode
  • - Number of Threads for Downloading Staging Files
  • - Data format of the staging file
  • - Local Stage File Directory
  • - Staging File Name
  • - Enable Staging File Compression
  • - Persist Destination Table
  • - pre SQL
  • - post SQL
  • - pre SQL Configuration
  • - post SQL Configuration
Target
  • - Target Dataset ID
  • - Target Table Name
  • - Create Disposition
  • - Write Disposition
  • - Write Mode
  • - Streaming Template Table Suffix
  • - Rows per Streaming Request
  • - Staging File Name
  • - Data format of the staging file
  • - Persist Staging File After Loading
  • - Enable Staging File Compression
  • - Job Poll Interval In Seconds
  • - Number of Threads for Uploading Staging File
  • - Local Stage File Directory
  • - Allow Quoted Newlines
  • - Field Delimiter
  • - Allow Jagged Rows
  • - pre SQL
  • - post SQL
  • - pre SQL Configuration
  • - post SQL Configuration
  • - Quote Char