Hello,
For my job, I am updating a model with an explore extend. In that extend, I am joining the base explore to a view that doesn't have an explore yet. I'm creating an explore from that view as part of the same update.
The primary reason for the join is to create an access filter from one of the fields in that view. For some reason, when I validate the LookML, I keep getting an "unknown access filter" error. I know the view exists, and that the field exists. I will say that the view doesn't have a primary key at the moment, but I've been told that shouldn't matter.
What kinds of issues could be causing this kind of error? I know I haven't provided a lot of detail, since this is for my job, but what are some common causes that I might look into? Do I need to make the view into an explore first, and then add the access filter, or is it something different?
Thank you in advance.
Some checks which may be helpful:
Is the view in the same folder with the rest of the views?
Is it included under the 'include' parameter, so that the model can see it?
Finally, is the scoping of the field correct? This might be a difference in using from
vs. view_name
on the base explore, or how you are scoping the field in the access_filter to the new extending view instead of the extended view. Referencing this section here: https://docs.looker.com/reference/explore-params/extends#definition to be specific - can you try using a view_name parameter instead to see if that satisfies the validation?