skip to main content
Quick Start: Progress DataDirect for JDBC for Google BigQuery Driver : Using connection properties
  

Try DataDirect Drivers Now

Using connection properties

You can use connection properties to customize the driver for your environment. You can use these connection properties with either the JDBC Driver Manager or a JDBC DataSource. For a Driver Manager connection, a property is expressed as a key value pair and takes the form property=value. For a DataSource connection, a property is expressed as a JDBC method and takes the form setProperty(value). For a complete list of supported properties, refer to "Connection Property Descriptions" in the Progress DataDirect for JDBC for Google BigQuery Driver User's Guide
The following table summarizes the minimum connection properties required to connect to a database. For a list of properties that affect performance, see "Tuning for Performance."
Note: All connection property names are case-insensitive. For example, AccessToken is the same as accesstoken. Required properties are noted as such.
Note: The data type listed for each connection property is the Java data type used for the property value in a JDBC DataSource.
Table 1. Required Properties
Property
Characteristic
Project
Specifies the name of the project that you want the driver to connect to. The projects in Google BigQuery are equivalent to catalogs in JDBC.
Dataset
Specifies the name of the dataset that you want the driver to connect to. The datasets in Google BigQuery are equivalent to schemas in JDBC.
AccessToken
Specifies the access token used to authenticate to a Google BigQuery instance.
RefreshToken
Specifies the refresh token used to either request a new access token or renew an expired access token. If an access token is not provided or expires at the time of connection, the access token generated using refresh token is used to authenticate to a Google BigQuery instance.
ClientID
Specifies the consumer key for your application. The driver uses this value when authenticating to a Google BigQuery instance.
ClientSecret
Specifies the consumer secret for your application. The driver uses this value when authenticating to a Google BigQuery instance.