Buffer Refill Error with SQL Query from Databricks

[BB22]

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.

[BrandonB]

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]

Simba Spark OBDC Driver v 1.2.9.1010 (64 bit)

[BrandonB · Accepted solution]

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]

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.