Connection to Databricks

Hi to everyone!
I need help because I must connect Knime to a Datalake built into Databricks.
Which node can I use? Databricks System File Connector node?
Should I need any specific information, besides URL and username/password?

Many thanks
Giada

Hi @giad -

You might take a look at this workflow to get some ideas. It’s a bit busy, but only because it’s trying cover many different potential applications in the same workflow as examples.

1 Like

Hi!
I cannot install the “knime databricks integration” extensions because I receive this error:
“KNIME Databricks Integration” will be ignored because it is already installed.
But it is not installed yet.
When I try to find: databricks into the node repository i don’t see anything.

What is the problem?
Thanks
Giada

This suggests some sort of problem with the version of your update sites. What version of KNIME AP are you using, and on what operating system?

If you go to Preferences → Install/Update → Available Software Sites, what do your sites look like? Here’s an example of mine:

here mine:

Is the version the problem?

The version in your updates sites should match the version of KNIME AP you’re using - in my case, it’s 5.1 to 5.1. If it does, you’re running into some other issue.

In that case you might try a separate installation of KNIME AP (using the ZIP file) to try and get the extensions installed there.