DB WRITER CONFIGURATION IN KNIME FOR DATABRICKS WRITE

[trafalgarlaw]

Hello, may I ask what are the configuration for DB Writer as I am trying to connect it in Databricks. Really not sure what to put so it can write into my table in Databricks. Thank you so much!

[ScottF]

Hi @trafalgarlaw -

If you’re still stuck on this, I’d recommend taking a look at some of the Databricks example we have on the KNIME Community Hub. There are quite a few: Search – KNIME Community Hub

Here’s a simple workflow that may help:

Databricks SQL Warehouse – knime

[tobias.koetter]

Hello @trafalgarlaw ,

we also have a Databricks User guide that should help you to get started.

In general the DB Writer works for Databricks but only for small amounts of data since it is very slow. I would recommend to use the DB Loader instead as described in the guide.

Bye
Tobias