Auto Populate allowed_value: in Parameter/Filter-Only Field

[PaulM1]

Is it possible to query a table, and load all the results from one of the columns into the allowed values of a Parameter/Filter-Only Field?

[izzymiller]

I don’t think it’s possible to fill in the allowed_values of a parameter, but you can use the values as a filter-- See my response here linking out to two other posts

Can we use the results of one Look as filters of other Look dynamically? LookML

@quinn_morrison had some advice about this here: I think the second option, though more complex, might be what you’re looking for. I also had a different workflow that uses the API, here:

[Cyril_MTL_Analy]

Can’t you use the suggest_dimension parameter?

[izzymiller]

You can use suggest_dimension, but it isn’t the most flexible choice. You can’t really take the results of a true query and load them into a dimension to use as a suggest_dimension.

If you have something simpler, then that would work fine, but if you start needing lots of filters and special conditions you wouldn’t be able to leverage it. Excellent idea though, I hadn’t even considered it!