BigQuery - Database Writer very slow

Hi everyone!

I have a simple table with 15k rows and I’m trying to write in my BigQuery database. The node connection is working but when I try to write it takes a long time - like all day. I already try to change my network connection.

Any idea what’s happening?

Hello @marioferroni,

welcome to KNIME Community!

It’s suggested to use DB Loader node to write data to BigQuery since the JDBC driver has limitations:
https://cloud.google.com/bigquery/docs/reference/standard-sql/data-manipulation-language#limitations

Br,
Ivan

2 Likes

Perfect, tks a lot!!

1 Like

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