Adding the proper window specification for the "OVER" clause plus DISTINCT helps to achieve some resemblance of STRING_AGG for the simple ascending order:select distinct
object
,array_join(array_sort(collect_set(property) over (partition by ...
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 parame...
