BigQuery Connector

Hi guys,

 

I am trying to connect using the Simba JDBC Driver, but I have different doubts.

What should I include in the Database URL, username and password?

I have linked BigQuery to Google Analytics and I have been able to query through the BigQuery console, but at the time of wanting to do it from BigQuery, I can not connect.

 

Thanks.

Hi,

accroding to the driver documentation that is included in the driver zip file you specify all connection information via paramters in the JDBC url. So you do not need to enter a username and password in the filed in the Databse Connector node in KNIME.

You can either use a Google Service Account (see page 14) or the Google User Account method (page 13). However I have no no idea how the driver returns the URL and requests the access token. Maybe you can give both methods a try and report back the results.

Bye

Tobias