Google BigQuery Connection via JDBC

[kotvir]

Hi All,

I am trying to establish Connection with Google BigQuery via SIMBA JDBC Adapter in Talend Open Studio.

I am using following format for JDBC URL.

jdbc:bigquery://{host}:{port};ProjectId={database};OAuthType=0;OAuthServiceAcctEmail={user};OAuthPvtKeyPath={server};\

Keeping user name and password empty.

I am getting following error while trying to setup connection.

[Anonymous]

Hello,

From the trouble screenshot, there are missing jar issue.

Did you download all required simba drivers and added the JARS into Talend?

Best regards

Sabrina