Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Buffer Refill Error with SQL Query from Databricks

BB22
5 - Atom

When utilizing the input tool to query Databricks with SQL, I get the following error message, consistently, after about 16 minutes:

 

Error: Input Data (1): Error SQLExecute: [Simba][Hardy] (34) Error from server: Could not refill buffer.

 

Not a problem when running in native databricks environment, and only returns about 100k rows, so not a size limitation.

 

Any insight is appreciated. Thanks in advance.

4 REPLIES 4
BrandonB
Alteryx
Alteryx

Do you know what driver you are using for the ODBC connection?

 

Connecting to Databricks through Alteryx: https://help.alteryx.com/current/DataSources/Databricks.htm

 

Apache Spark on Databricks: https://help.alteryx.com/current/DataSources/SparkDatabricks.htm

BB22
5 - Atom

Simba Spark OBDC Driver v 1.2.9.1010 (64 bit)

BrandonB
Alteryx
Alteryx

If you wouldn't mind giving it a try, can you download the driver found at https://pages.alteryx.com/Alteryx-Driver-Downloads-LP.html

 

That way we can rule out the driver being the issue

BB22
5 - Atom

Looks like that did it!  For some reason I had two Simba Spark ODBC drivers, each with a different version than the one you pointed me to.  Uninstalled both and installed new one, and seems to be working fine now.  Thanks so much.

Labels