Note that as of Looker 3.48,
sql_always_wherewill not prevent suggestions from populating.
full_suggestions: truewill be applied to all fields that are exposed by an explore that uses
sql_always_whereparameters. For more information, see the
The following applies to pre-3.48 Looker versions.
You may have a field that should be populating suggestions when you add it as a filter in Explore. In most situations, string filters will suggest possible values by default. Read more about how suggestions are populated here.
However, if you have
sql_always_where defined on an explore, fields in that explore will not automatically provide suggestions when filtered. This is because auto-suggestions for dimensions are disabled in explores that use
sql_always_where to prevent users from seeing any values they should not be seeing. Both normal explore filters and dashboard filters of type
field_filter are impacted.
If you would like to enable suggestions for explores with
sql_always_where, read about the
full_suggestions parameter here.