KB486844: JDBC Connection strings from Strategy to Google BigQuery

Depending on the selected Authentication mode, the JDBC connection string will look slightly different.

Token Authentication Mode

It uses a RefreshToken, which can be generated by following the manual of Generate a Refresh Token to Access Google BigQuery . 
The connection string has to include an OAuthRefreshToken parameter as below:

JDBC;DRIVER={com.Strategy.googlebigquery.jdbc42.Driver};URL={jdbc:bigquery://https://www.googleapis.com/bigquery/v2;ProjectId=;OAuthType=0;OAuthRefreshToken=?MSTR_OAUTH_REFRESH_TOKEN;OAuthClientId=?MSTR_OAUTH_CLIENT_ID;OAuthClientSecret=?MSTR_OAUTH_CLIENT_SECRET;Timeout=600;EnableHighThroughputAPI=1}

 

OAuth Authentication Mode

A JDBC connection using OAuth Authentication Mode can only be set up in Strategy Workstation – Strategy Developer does not support OAuth Authentication Mode.
The example of connection string as below:

JDBC;DRIVER={com.Strategy.googlebigquery.jdbc42.Driver};URL={jdbc:bigquery://https://www.googleapis.com/bigquery/v2;ProjectId=;OAuthType=2;OAuthClientSecret=?MSTR_OAUTH_CLIENT_SECRET;Timeout=600;EnableHighThroughputAPI=1}

Please makes sure that the OAuthPvtKeyPath is correct – if it is connecting from Strategy Cloud Platform, this path needs to be accessible from anywhere. It cannot be a path to a local folder. The MCE environment is located on Linux, so the path needs to be a Linux path to where the file is located and accessible by Cloud environment. Reach out to Strategy Cloud Support to ask for the exact path location.
For other parameters, please refer the manual of Configure OAuth Parameters for Google BigQuery .
 

OIDC Single Sign-On

Please follow the steps of Integrate Strategy with Azure AD OIDC for Google BigQuery Single Sign-On in Workstation .