I'm new to all this Databricks stuff and I've immediately run into this "UNBOUND_SQL_PARAMETER" error after trying to be "fancy" with my parameters (query-bound).

My workaround after multiple trial and errors was to switch from the newer "Named parameter marker syntax" (i.e., :parameter_name) to original(?) "Mustache parameter syntax" (i.e., {{parameter_name}}). This worked for me.

Details:

Query Editor

A "simple" SELECT with "Query Based Dropdown" parameter.

Using "Named parameter marker syntax" leads to following error:

[UNBOUND_SQL_PARAMETER] Found the unbound parameter: CompanyCode. 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 116, pos 21

Simple "text"/"number" type of parameters work with either syntax.

It's clearly a bug but at this point I don't have enough knowledge to confidently point to culprit.

Hope this helps somebody.