Coneccting Knime to the Google Big Query via ODBC

KNIME Analytics Platform
1

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.

2

Hi @john_sousa and welcome to the forum.

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

3

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?

4

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

5

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