"You have found a bug. The pipe has been ended" error when connecting to Databricks ODBC

[st]

Tool: Input Tool

Version: 2023.1.1.123

Hi, 

I have encountered this error message: "Error: Designer x64: The Designer x64 reported: You have found a bug. The pipe has been ended." when connecting to Databricks ODBC. Looking for solutions. Thank you!

[apathetichell]

Where are you seeing this specifically - shoot me a message. I work with Databricks in Alteryx and see this kind of thing all the time (or did - before I understood limitations and got my set up done).

[st]

from my input tool: 

[geraldo]

@st 

did you put a browse tool in the output ?

[apathetichell]

@geraldoprobably won't show anything.

@st First question - have you connected to DB before in Alteryx. I connect via In-DB only. I write via datastream in - only.  I only write via csv bulk loader. I tested a ton of different combos and stick with these because they work. I'm on AWS Databricks.

[st]

Thank you both @apathetichell , @geraldo for looking into this...
It has been solved.. 

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Knowledge-Base/Error-Get-Table-List-Error-...

It was an ODBC driver compatibility issue, after I uncheck the "Get table with Query" in the ODBC configuration suggested from the link above, no error message!!!

[dunkindonut7777]

hello can  you state the step by step procedure? I kina lost in the procedure stated in the link mentioned. Thank you