community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Buffer Refill Error with SQL Query from Databricks

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.

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

Atom

Simba Spark OBDC Driver v 1.2.9.1010 (64 bit)

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

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