Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Databricks connection fails

Highlighted
8 - Asteroid

I'm trying to set up a connection to Databricks, but get two errors: [Simba][Hardy] (34) Error from server: Could not resolve host for client socket.. and drivers sql set connect attr failed.

 

I followed this tutorial https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-To-Configure-a-Databricks-Conne... and have attached screenshots of my setup.

 

Any help would be appreciated.

 

Luisa_Bez_0-1579865159185.png

 

Luisa_Bez_1-1579865289187.png

Luisa_Bez_2-1579865324209.png

Luisa_Bez_3-1579865346583.png

Luisa_Bez_4-1579865659413.png

Luisa_Bez_5-1579865693851.png

Luisa_Bez_6-1579865727745.png

Highlighted
Alteryx Partner

Hi @Luisa_Bez 

 

I'm not a Databricks expert but I would check two things. Make sure that the host is a Databricks cluster JDBC/ODBC Server hostname (per https://help.alteryx.com/current/DataSources/Databricks.htm) and I would also not leave it to default for the database. See if you can select/type in a specific database. 

 

 
Highlighted
8 - Asteroid

Hi @joshuaburkhow,

 

Thanks for your reply.

 

I changed the setting from default to Databricks for the database, but unfortunately I still get the same errors.

Highlighted
Alteryx Partner

Hi @Luisa_Bez 

 

I think your next best option is to reach out to support@alteryx.com and see if they can help.!

 

Best of luck 🙂

Joshua

Highlighted
8 - Asteroid

I found a solution. Instead of connection to "Databricks" I had to connect to "Apache Spark on Databricks". I can then select my cluster and stream in data.

Labels