Hi everyone,

We're seeing a change in the behavior of multi-select dashboard parameters in Databricks SQL dashboards.

Previously, when no value was selected in a multi-select filter, our query logic worked as expected using:

SIZE(:my_parameter) = 0

However, starting recently, the same dashboards no longer behave as expected on the initial page load. It appears that the parameter is now resolving to NULL instead of an empty array ([]).

This has affected multiple dashboards that were previously working without any changes.

Has anyone else experienced this behavior?

Specifically:

Has there been a recent change in how Databricks SQL or Lakeview Dashboards initialize unset multi-select parameters?

Is this expected behavior or a known issue?

What is the recommended way to handle an unselected multi-select parameter now?

We're currently using logic similar to:

WHERE SIZE(:my_parameter) = 0

OR column_name IN (:my_parameter)

Any guidance or recommended workaround would be appreciated.

Thanks!