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;
AdChoices