|
Connection Options: Advanced
|
Description
|
|
Determines whether the driver creates a new schema map when establishing the connection.
If set to 0 - No, the driver uses the current schema map specified by the Schema Map option. If one does not exist, the connection fails.
If set to 1 - ForceNew, the driver deletes the current schema map specified by the Schema Map option and creates a new one at the same location.
If set to 2 - NotExist, the driver uses the current schema map specified by the Schema Map option. If one does not exist, the driver creates one.
Default: 2 -NotExist
|
|
|
Determines whether the driver automatically refreshes the map of the data model when a user performs a DDL operation (Create or Drop).
If enabled, the driver automatically refreshes the map of the data model when a user performs a DDL operation.
If disabled, the driver does not refresh the map of the data model when a user performs a DDL operation.
Default: Enabled
|
|
|
Determines whether the driver works with applications using multiple ODBC threads.
If enabled, the driver works with single-threaded and multi-threaded applications.
If disabled, the driver does not work with multi-threaded applications. If using the driver with single-threaded applications, this value avoids additional processing required for ODBC thread-safety standards.
Default: Enabled
|
|
|
Specifies the Google BigQuery SQL dialect to be used for querying data.
If set to standard, the driver uses the standard SQL dialect for querying data.
If set to legacy, the driver uses the legacy SQL dialect for querying data.
Default: standard
|
|
|
Determines whether the driver returns results larger than 128 MB for legacy SQL queries.
If disabled, the driver does not support query results larger than 128 MB.
If enabled, the driver supports query results larger than 128 MB.
Default: Disabled
|
|
|
Specifies the dataset where results for legacy SQL queries are stored when Allow Large ResultSet is enabled (AllowLargeResultSet=true).
Default: _queries_
|
|
|
Specifies the table where results for legacy SQL queries are stored when Allow Large ResultSet is enabled (AllowLargeResultSet=true).
Default: _sql_*
|
|
|
Specifies the customer-managed encryption key (CMEK) that the driver uses for executing queries. If it is not specified, the driver uses the default key encryption key from Google.
Default: None
|
|
|
Specifies the geographical location where your dataset is stored. Google BigQuery allows storing datasets in either one single geographical place, such as Tokyo, or a large geographical area, such as Europe.
Default: None
|
|
|
Specifies a space-separated list of OAuth scopes that limit the permissions granted by an access token at the time of connection.
Default: https://www.googleapis.com/auth/bigquery
|
|
|
Controls how data conversions are handled for null values.
If disabled, the driver does not perform the data type check if the value of the column is null. This allows null values to be returned even though a conversion between the requested type and the column type is undefined.
If enabled, the driver checks the data type being requested against the data type of the table column that stores the data. If a conversion between the requested type and column type is not defined, the driver generates an "unsupported data conversion" exception regardless of whether the column value is NULL.
Default: enabled
|
|
|
Determines whether the driver uses Google BigQuery's query cache to save results.
If enabled, the driver uses query cache to save results.
If disabled, the driver does not use query cache.
Default: enabled
|
|
|
Specifies the time, in seconds, that the driver waits for a job to run before timing it out.
If set to 0, the driver waits indefinitely for a job to run; there is no timeout.
If set to x, the driver uses the value as the default timeout for any job run against a Google BigQuery instance.
Default: 0
|
|
|
Specifies the maximum number of bytes a query can read. As per the on-demand pricing model of Google BigQuery, charges are billed based on the number of bytes a query reads. To control the cost a query may incur, you can set a limit. Once the limit is exceeded, the query fails without incurring any cost.
If set to 0, the driver allows queries to read indefinite amount of data; there is no limit.
If set to x, the driver uses the value as the limit beyond which queries fail without incurring any cost.
Default: 0
|
|
|
Specifies the billing tier that you have access to. If you query a resource beyond the limit set for your tier, the query will fail without incurring any cost.
Default: 0
|
|
|
The number of seconds the driver waits for a connection to be established before returning control to the application and generating a timeout error.
If set to -1, the connection request does not time out. The driver silently ignores the SQL_ATTR_LOGIN_TIMEOUT attribute.
If set to 0, the connection request does not time out, but the driver responds to the SQL_ATTR_LOGIN_TIMEOUT attribute.
If set to x, the connection request times out after the specified number of seconds unless the application overrides this setting with the SQL_ATTR_LOGIN_TIMEOUT attribute.
Default: 15
|
|
|
Specifies the number of rows that the driver processes before returning data to the application. Smaller fetch sizes can improve the initial response time of the query. Larger fetch sizes improve overall fetch times at the cost of additional memory.
Default: 100
|
|
|
The number of seconds the driver waits for a connection to be established before returning control to the application and generating a timeout error.
If set to 0 - Ignore Errors, the driver substitutes 0x1A for each character that cannot be converted and does not return a warning or error.
If set to 1 - Return Error, the driver returns an error instead, the driver returns an error instead of substituting 0x1A for unconverted characters.
, the driver returns an error insteadIf set to 2 - Return Warning, the driver substitutes 0x1A for each character that cannot be converted and returns a warning.
Default: 0 - Ignore Errors
|
|
|
Determines the JSON string format in which the driver returns values for complex data types, such as Array and Struct.
If set to raw, the values are returned in their native Google BigQuery format.
If set to keyvalue, the values are returned in key value pairs. Also, if there is a closing curly bracket (}) or a back slash (\) in a value, the driver escapes it by adding a back slash (\) in front of it. For example, if the value is "8}", the driver returns it as "8\}".
If set to pretty, only the values are returned (unaccompanied by keys).
If set to unsafe, the values are returned in key value pairs. However, if there are any special characters in them, they are not escaped.
Default: raw
|
|
|
Specifies the filename of the configuration file used to initialize the driver logging mechanism. If the driver cannot locate the specified file when establishing the connection, the connection fails and the driver returns an error.
Default: None
|
|
|
Determines how the mapping of the remote Google BigQuery data model to a local schema map can be configured, customized, and updated.
Default: None
|
General tab allows you to configure options that are required for creating a data source.If set to allows you to configure options that are required for
SQL Engine tab allows you to configure the SQL Engine's behavior.
Web Service tab allows you to configure the behavior of communications between the driver and web service.
Pooling tab allows you to configure connection pooling behavior.
Bulk tab allows you to configure the driver to use the Google BigQuery Storage API.