And I can't submit a feature request because when I select feedback I get: HTTP ERROR 403Problem accessing /sso/ideas. Reason: Invalid or missing CSRF token
I have a similar problem and none of the above proposals work. I'm trying to do an array_overlap(column_array, user_input_array). The user_input_array should be optional. So I can do something like select case when cardinality(column_array) = 0 or ...
Also, the mere fact that {{}} exists in the SQL will cause Databricks console to error it. While debugging I had actually moved the parameter {{}} part to a SQL comment -- {{}} and the console errors it even though it's only in a comment so obviousl...
