topic Re: Connection to Databricks through KNIME in Data Engineering

Connection to Databricks through KNIME

Geetha — Wed, 08 Feb 2023 08:35:11 GMT

I want to make a connection to Databricks with KNIME. To do this I am using "Create Databricks Environment" node. I have made the following configuration:

1. Installed Databricks Simba JDBC driver

2. Made the necessary configuration in Create Databricks Env

But when I execute the node, I am receiving the error "Execute failed: [Simba][SparkJDBCDriver](700100) Connection timeout expired. Details: None.".

As per some suggestions "I tried to increase the termination timeout of the Databricks Cluster in the Cluster Configuration" to resolve the error.

It doesn't help me to resolve the issue.

Can anyone help me to resolve it?

Thanks in advance!!

Re: Connection to Databricks through KNIME

Anonymous — Tue, 07 Mar 2023 08:16:39 GMT

@Geethanjali Nataraj : Can you try to verify that you have the correct network settings to make sure that your KNIME server can communicate with your Databricks environment. Check that you have the correct network settings, such as IP addresses and firewall rules, configured.

Re: Connection to Databricks through KNIME

Anonymous — Sat, 08 Apr 2023 07:35:37 GMT

Hi @Geethanjali Nataraj

Hope everything is going great.

Just wanted to check in if you were able to resolve your issue. If yes, would you be happy to mark an answer as best so that other members can find the solution more quickly? If not, please tell us so we can help you.

Cheers!