skip to main content
Connection Option Descriptions
  

Try DataDirect Drivers Now

Connection Option Descriptions

The following connection option descriptions are listed alphabetically by the GUI name that appears on the driver Setup dialog box. The connection string attribute name, along with its short name, is listed immediately underneath the GUI name.
In most cases, the GUI name and the attribute name are the same; however, some exceptions exist. If you need to look up an option by its connection string attribute name, please refer to the alphabetical table of connection string attribute names.
Also, a few connection string attributes do not have equivalent options that appear on the GUI. They are in the list of descriptions alphabetically by their attribute names.
The following tables list the connection string attributes supported by the Google BigQuery driver.

Required attributes

The following table summarizes attributes that are required to connect to a Google BigQuery instance when the default authentication method, OAuth 2.0, is used for authentication.
Table 5. Required attributes
Attribute (Short Name)
Default
None
oauth2
None
None
None
None
None
None
None

Mapping attributes

The following table summarizes attributes involved in mapping the remote Google BigQuery data model to a local schema map used to support SQL queries against Google BigQuery.
Table 6. Mapping attributes
Attribute (Short Name)
Default
VarcharLength=65535; SchemaSet=;
2 (NotExist)
For OAuth 2.0 authentication:
*Windows platforms:
*User data source: user_profile\AppData\Local\Progress\ DataDirect\GoogleBigQuery_Schema\ ClientID.config
*System data source: C:\Users\Default\AppData\Local\ Progress\DataDirect\GoogleBigQuery_Schema\ ClientID.config
*UNIX/Linux platforms:~/progress/datadirect/ GoogleBigQuery_schema/ClientID.config
where
ClientID
is either the complete value of the client ID (if the client ID is shorter than or equal to 30 characters) or the first 15 and last 15 characters of the client ID (if the client ID is longer than 30 characters).

OAuth 2.0 attributes

The following table summarizes attributes that are used for OAuth 2.0 authentication.
Table 7. OAuth 2.0 attributes
Attribute (Short Name)
Default
None
None
None
None
https://www.googleapis.com/ auth/bigquery

Service account attributes

The following table summarizes attributes that are used for service account authentication.
Table 8. Service account attributes
Attribute (Short Name)
Default
None
None

Storage API attributes

The following table summarizes attributes that are used to leverage the Google BigQuery Storage API when fetching large result sets.
Table 9. Storage API attributes
Attribute (Short Name)
Default
3 (pages)
10000 (pages)
false

Legacy SQL attributes

The following table summarizes attributes that can be used to execute queries using legacy SQL.
Table 10. Legacy SQL attributes
Attribute (Short Name)
Default
false
_queries_
_sql_*
standard

Proxy server attributes

The following table summarizes proxy server attributes.
Table 11. Proxy server attributes
Attribute (Short Name)
Default
Empty string
Empty string
Empty string
Empty string

Web service attributes

The following table summarizes web service attributes, including those related to timeouts.
Table 12. Web service attributes
Attribute (Short Name)
Default
1000000
1
0
120 (seconds)

Timeout attributes

The following table summarizes timeout attributes.
Table 13. Timeout attributes
Attribute (Short Name)
Default
0 (no timeout)
15
15
120 (seconds)

Pooling attributes

The following table summarizes pooling attributes.
Table 14. Statement pooling attributes
Attribute (Short Name)
Default
0
0
0
100
0

Additional attributes

The following table summarizes additional attributes.
Table 15. Additional attributes
Attribute (Short Name)
Default
1
1
100 (rows)
4 (ISO 8559-1 Latin-1)
raw
For the 32-bit driver when the SQL Engine Mode is set to 2 (Direct):
-Xmx256m
For all other configurations:
-Xmx1024m
install_dir\java\lib\googlebigquery.jar
None
None
Empty string
0 (no limit)
0
1
true
0(Ignore Errors)
For 64-bit: 19946
For 32-bit: 19945
For Windows: 0 (Auto)
For UNIX/Linux: 2 (Direct)
1
* Access Token
* Allow Large ResultSet
* Application Using Threads
* Authentication Method
* Client ID
* Client Secret
* Config Options
* Connection Pooling
* Connection Reset
* ConvertNull
* Create Map
* Dataset
* Data Source Name
* Description
* Fetch Size
* IANAAppCodePage
* Job Timeout
* Json Format
* JVM Arguments
* JVM Classpath
* KMSKeyName
* Legacy Dataset
* Legacy Table
* Location
* LoadBalance Timeout
* Log Config File
* Login Timeout
* MaximumBytesBilled
* MaximumBilling Tier
* Max Pool Size
* Min Pool Size
* Project
* Proxy Host
* Proxy Password
* Proxy Port
* Proxy User
* Refresh Schema
* Refresh Schema For DDL
* Refresh Token
* Report Codepage Conversion Errors
* Schema Map
* Scope
* Server Port Number
* Service Account Email
* Service Account Private Key
* SQL Engine Mode
* Storage API Min Page Count
* Storage API Threshold
* Syntax
* UseQueryCache
* Use Storage API
* WSFetch Size
* WSPoolSize
* WSRetry Count
* WSTimeout