Error Connecting to the Big Query

[sridhar5999]

I have configured the Big Query Data base and mentioned in the Knime website and the Google driver configured is of version 1.3.0.

Google Authentication is running successfully but the Google Big Query connector is throwing error when I try to run it.

Caused by: java.lang.ClassNotFoundException: com.google.auth.Credentials
at java.base/java.net.URLClassLoader.findClass(Unknown Source)
at java.base/java.lang.ClassLoader.loadClass(Unknown Source)
at java.base/java.lang.ClassLoader.loadClass(Unknown Source)

Could you people help me in connecting to the Big Query?

[ScottF]

Hi @sridhar5999 and welcome to the forum.

I am not an expert on Bigquery, but maybe I can help. Have you seen our documentation about connecting to Bigquery here? KNIME Google Cloud Integration User Guide

In particular I would double check to see if

1. you have created a P12 service account
2. you are using the recommended driver (which appears to be a particular version of the Simba driver linked in the docs above)
3. you are configuring the Google Authentication (API Key) node as shown here: KNIME Google Cloud Integration User Guide

If you follow the guidance in the docs as listed, do you still see the same error?

[sridhar5999]

Thank you so much @ScottF it workes now.

Actually I was using JDBC driver version 1.3.0, but the link you shared has version 1.2.0 and this worked fine for me.

I am closing this issue as resolved.