Importing data into Excel from Databricks over ODBC OAuth / Simba Spark Driver

[Michael_Galli]

Hi all,
I am refering to this article
Connect to Azure Databricks from Microsoft Excel - Azure Databricks | Microsoft Learn

I use the latest SimbaSparkODBC-2.8.2.1013-Windows-64bit driver and configured in like in that documentation.
In Databricks I use a Serverless Warehouse (Current, v 2024.25)
I use Windows 11, Excel version 2403

Now when filtering data in Excel - Power query on that warehouse, in the Databricks query history I get the following error:

[UNBOUND_SQL_PARAMETER] Found the unbound parameter: _753. Please, fix `args` and provide a mapping of the parameter to either a SQL literal or collection constructor functions such as `map()`, `array()`, `struct()`. SQLSTATE: 42P02; line 36 pos 18

The query looks like this -> note the "?"

select
  `COLUMN1`,
from
  `catalog`.`schema`.`table`
where
  `PERIOD` = ?  and `PERIOD` is not null

Any idea on how to fix this?

[raphaelblg]

Hi @Michael_Galli, I've never seen this scenario before. Given the fact you're using a MSFT tech stack I'd recommend opening a support ticket with MSFT. 

[Michael_Galli]

Can you provide a link please?

[raphaelblg]

@Michael_Galli, MSFT team should evaluate, if they can resolve the issue they will. If determined to be a Databricks/Simba issue, Databricks team will get involved.

https://azure.microsoft.com/en-us/support/create-ticket