Databricks - INSERT is not supported by Databricks.

Hi
I’m trying to write data into Databricks. Reading from an existing table, and creating a new table are both fine.

When I try to write to a new table, the table is created correctly but then the Insert fails with the error Execute failed: INSERT is not supported by Databricks.

Any ideas?

Cheres
Charlie

Hello @charlespickett,

and welcome to KNIME Community!

Maybe your problem is due to the driver you are using. Anyways there are different nodes to write data from KNIME into DB. I would give DB Loader a try as it’s used in Databricks example workflows. (see here Related Workflows part for workflow examples with Databricks integration)

Additionally here is part of DB documentation that explains connection from KNIME to various databases:

https://docs.knime.com/latest/db_extension_guide/index.html#connecting_examples

(look for Connecting to Databricks paragraph :wink: )

Br,
Ivan

2 Likes

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