suggestable

Usage

view: view_name {
  dimension: field_name {
    suggestable: yes 
  }
}

Hierarchy View File view Field Type suggestable

Possible Field Types Dimension, Dimension Group, Measure, Filter, Parameter Accepts A Boolean (yes or no)

Definition

When a user filters an Explore on a field that supports suggestions, by default Looker will suggest possible values for the field (see Changing filter suggestions for information about how you can affect filter suggestions).

The suggestable parameter lets you disable suggestions for a field when a user filters on that field in a Look or an Explore. The default value of suggestable is yes, and suggestions are provided when possible. If you set suggestable to no, Looker won't suggest values for the field.

Note: If the field's view is defined with suggestions:no, Looker won't provide suggestions for any field in the view, even if the field is defined with suggestable:yes.

Examples

Prevent Looker from providing filter value suggestions for the name dimension:

dimension: name {
  type: string
  sql: ${TABLE}.name ;;
  suggestable: no
}