coldfusion and bigquery

Report · May 28, 2019

Anyone have any experience setting up the Simba JDBC driver for Google BigQuery using service account authentication?

The problem seems to be reading the file which is defined in the OAuthPvtKeyPath which is a part of the JDBC URL.

When I submit the form with the JDBC URL, Driver Class, Driver Name etc I receive the following error:

java.sql.SQLNonTransientConnectionException: [Simba][JDBC](10100) Connection Refused: [Simba][JDBC](11640) Required Connection Key(s): OAuthPvtKeyPath, OAuthServiceAcctEmail, ProjectId

All three parameters (OAuthPvtKeyPath, OAuthServiceAcctEmail and Projectid) is part of the JDBC URL like this example from the Simba JDBC driver user manual (except from the OAuthPvtKeyPath which is the path I'm using on my Mac):

jdbc:bigquery://https://www.googleapis.com/bigquery/v2:443;

ProjectId=MyBigQueryProject;OAuthType=0;

OAuthServiceAcctEmail=bqtest1@data-drivertesting.

iam.gserviceaccount.com;

OAuthPvtKeyPath=/Applications/ColdFusion2018/cfusion/lib/myfilewithkeys.json;