Coneccting Knime to the Google Big Query via ODBC

Does anyone know how to connect knime to big query using ODBC? I already tried with the API and JDBC, but I was not able to do it.

Hi @john_sousa and welcome to the forum.

I don’t believe connection via ODBC is currently supported. Sorry about that.

Hi, Scott! Thank you for the reply. Do you have any idea how can I connect to Google Big Query? I tried to use API, but it’s a corporative account, and it was not possible to connect.
And I also tried to use JDBC, but it didn’t connect. Is there any other way to do it?

We have some examples on the KNIME Community Hub that I hope will help you get started:

Hello @john_sousa,

JDBC connection is the proper way to go. Maybe this part of documentation will help:
https://docs.knime.com/latest/google_cloud_integration_user_guide/index.html#google_bigquery

Additionally there are many topics discussing Google BigQuery connection so I suggest to take a look if you’ll still have issues.

Welcome to KNIME Community!

Br,
Ivan

1 Like

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.