topic Re: No suitable driver found for JDBC Google BigQuery connection in Talend Studio

No suitable driver found for JDBC Google BigQuery connection

XULACS96 — Fri, 15 Nov 2024 23:48:56 GMT

I'm trying to create a DB Connection to Google BigQuery using JDBC driver from Simba drivers. I'm getting the error of No suitable drive for. Clearly I'm missing a driver/jar file but I have no idea what I'm missing and I'm hoping someone can help me successfully created a connection. I've downloaded the drivers/jar files from

https://cloud.google.com/bigquery/providers/simba-drivers. I selected the suggested driver class from the drop down. I've verified that my JDBC URL is correct. Any help would be appreciated. I'm using Talend Open Studio 7.3.1

Re: No suitable driver found for JDBC Google BigQuery connection

Anonymous — Wed, 25 Aug 2021 08:38:52 GMT

Hello,

You need to load the library firstly.

Please load the JDBC driver with tLibraryLoad component (before your own code comes in action) as even the components for the databases organizes the driver load, your code does not do this. Feel free to let us know if it works for you.

Best regards

Sabrina

Re: No suitable driver found for JDBC Google BigQuery connection

XULACS96 — Wed, 25 Aug 2021 13:48:07 GMT

xdshi,

I think my problem is I'm trying to create a DB Connection for Google BigQuery using a service account rather than OAuth. the GoogleBigQueryJDBC42.jar driver doesn't seem to support JDBC URL with google service account credentials. It would be nice if you could confirm this to be true and if it's not true how do I get the service account credentials to work. Just to be clear, I don't have any custom code, I am just trying to create DB Connection for Google BigQuery using the JDBC library.