Connection to Databricks through KNIME

[Geetha]

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!!

[Anonymous]

@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.

[Anonymous]

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!