Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
The Expert Exam is now live online! Read about the specifics and what it took to bring it to life in the blog by our very own Elizabeth Bonnell!
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