BigQuery Connector Node Execute failed

[Joshuajkitz]

Hi Folks,
I’ve done a bunch of troubleshooting and haven’t arrived at a solution. I’m getting
ERROR Google BigQuery Connector 4:11 Execute failed: com/google/auth/Credentials

This thread is similar:

Google Big Query Connector node not working

Hi everyone. First of all thanks to the great Knime Online Conference! It was a lot of fun and I learned a lot!!! BUT… I have a problem with the Google Big Query Connector node. I followed the tutorial here to get the node to work but I could not. Authentication with Google is fine but the connector fails with the following message: ERROR Google BigQuery Connector 0:1498 Execute failed: com/google/api/client/json/CustomizeJsonParser I made a new project, I created a new p…

But I’ve done the same fixes and haven’t had success.
Read documentation here: KNIME Google Cloud Integration User Guide and linked from there.

We’ve checked that the Service account and it does work. I’ll add my connection setup:

The error from logs:

2023-03-07 13:30:18,327 : ERROR : KNIME-Worker-22-Google BigQuery Connector 4:11 :  : Node : Google BigQuery Connector : 4:11 : Execute failed: com/google/auth/Credentials
java.sql.SQLException: com/google/auth/Credentials
	at org.knime.database.util.Futures.throwDatabaseExecutionException(Futures.java:112)
	at org.knime.database.connection.impl.DBConnectionManager.initializeConnection(DBConnectionManager.java:516)
	at org.knime.database.connection.impl.DBConnectionManager.<init>(DBConnectionManager.java:275)
	at org.knime.database.session.impl.DefaultDBSession.<init>(DefaultDBSession.java:223)
	at org.knime.database.session.impl.DBSessionFactory.create(DBSessionFactory.java:81)
	at org.knime.database.session.DBSessionCache.getOrCreate(DBSessionCache.java:151)
	at org.knime.database.node.connector.AbstractDBConnectorNodeModel.registerSession(AbstractDBConnectorNodeModel.java:389)
	at org.knime.database.node.connector.AbstractDBConnectorNodeModel.execute(AbstractDBConnectorNodeModel.java:219)
	at org.knime.core.node.NodeModel.executeModel(NodeModel.java:549)
	at org.knime.core.node.Node.invokeFullyNodeModelExecute(Node.java:1267)
	at org.knime.core.node.Node.execute(Node.java:1041)
	at org.knime.core.node.workflow.NativeNodeContainer.performExecuteNode(NativeNodeContainer.java:595)
	at org.knime.core.node.exec.LocalNodeExecutionJob.mainExecute(LocalNodeExecutionJob.java:98)
	at org.knime.core.node.workflow.NodeExecutionJob.internalRun(NodeExecutionJob.java:201)
	at org.knime.core.node.workflow.NodeExecutionJob.run(NodeExecutionJob.java:117)
	at org.knime.core.util.ThreadUtils$RunnableWithContextImpl.runWithContext(ThreadUtils.java:367)
	at org.knime.core.util.ThreadUtils$RunnableWithContext.run(ThreadUtils.java:221)
	at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
	at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
	at org.knime.core.util.ThreadPool$MyFuture.run(ThreadPool.java:123)
	at org.knime.core.util.ThreadPool$Worker.run(ThreadPool.java:246)
Caused by: java.lang.NoClassDefFoundError: com/google/auth/Credentials
	at com.simba.googlebigquery.googlebigquery.core.BQConnection.connect(Unknown Source)
	at com.simba.googlebigquery.jdbc.common.BaseConnectionFactory.doConnect(Unknown Source)
	at com.simba.googlebigquery.jdbc.common.AbstractDriver.connect(Unknown Source)
	at org.knime.database.connection.UrlDBConnectionController$ControlledDriver.connect(UrlDBConnectionController.java:103)
	at org.knime.database.connection.UrlDBConnectionController.connect(UrlDBConnectionController.java:368)
	at org.knime.database.connection.UrlDBConnectionController.createConnection(UrlDBConnectionController.java:348)
	at org.knime.database.connection.AbstractConnectionProvider.createConnection(AbstractConnectionProvider.java:103)
	at org.knime.database.connection.impl.DBConnectionManager.lambda$2(DBConnectionManager.java:501)
	at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.base/java.lang.Thread.run(Unknown Source)
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)
	... 12 more

Any help or suggestions most appreciated.

Edit to add - the only difference I see from setups in screenshots in the documentation and threads is that I have driver 1.3.0 where the examples seem to have 1.2

[Joshuajkitz]

So I had the right guess; it was the v 1.3 driver.

I downloaded the 1.2 driver from github and was able to get the connection working. GitHub - cppappserv/SimbaJDBCDriverforGoogleBigQuery42_1.2.1.1001

Feels like maybe a bug or something may need to be filed to let folks know this issue since 1.3 is the current version that googles documentation links too?

[ScottF]

Hi @Joshuajkitz - thanks for following up with the solution you found.