Thank you for your timely answer @mark_ott .

For clarification, I'm using a databricks dashboard (i believe in the newest form), with SQL warehouses. My dashboard doesn't event even allow the usage of the old parameter syntax:

I tried as you showed, but still could not get the dynamic list working. Here is an example of where I'm using it:

select
    conciliation_status,
    input_key_type,
    input_key,
    acquirer,
    input_date,
    first_effect_date,
    sum(input_amount) as input_amount,
    sum(1) as event_amount,
    sum(input_amount) / sum(sum(input_amount)) over (partition by input_key_type, input_date) as input_amount_percentage,
    sum(1) / sum(sum(1)) over (partition by input_key_type, input_date) as event_amount_percentage
from (
    select 
        * except(conciliation_id, conciliation_metadata, input_id, effect_date),
        effect_date[0] as first_effect_date,
        regexp_extract(input_key, '^[^.]+', 0) as input_key_type
    from acquirer_conciliation.final_edge
)
where array_contains(:p_choice_acquirer, acquirer)
group by conciliation_status, input_date, first_effect_date, input_key_type, input_key, acquirer
order by all

The problem is, on the UI, when i add the parameter, I get the following:

Where exactly should i include the sql code for this field? When i try to input on the field values itself, i got the follwoing:

The dashboard behaves as if i was inserting a string on the static list. This is not the behavior i want, obviously.

I tried creating other data sources and referencing them, but this also did not work.