Search code examples
apijdbcgoogle-bigquerydriverknime

Connect BigQuery with Knime

I'm trying to connect the with Knime the BigQuery API to download or make some querys at the Knime console, and I have some problems with the Driver.

I install de simba googlebigquery driver but don't works because I don't know how to complete this (<protocol>://<host>:<port>/<database_name>). Can anyone help me if knows how to run the driver?

Solution

  • The Install and Configuration Guide that comes with the JDBC driver has an example of a complete connection URL as:

    jdbc:bigquery://https://www.googleapis.com/bigquery/v2:443;P‌​rojectId=MyBigQueryP‌​roject;OAuthType=1

    The only part you should need to change is replacing MyBigQueryP‌​roject with your own project name.