Google BigQuery Connectors

Back Next

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

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

Upgrading to Google BigQuery V2 Connector

Download Guide

Watch

Comments

Cloud Connectivity Homepage

Communities

Knowledge Base

Success Portal

0 COMMENTS

We’d like to hear from you! Log in to comment.

Rename Saved Search

Table of Contents

Google BigQuery Connectors

Google BigQuery Connectors

Advanced properties retained after the switch

Advanced properties retained after the switch