home User Guide Getting Started Help Center Documentation Community Training Certification
menu
close
settings
Looker keyboard_arrow_down
language keyboard_arrow_down
English
Français
Deutsch
日本語
search
print
suggestions (for views)

This page refers to the suggestions parameter that is part of a view.

suggestions can also be used as part of a dimension or filter field, described on the suggestions (for fields) parameter documentation page.

Usage

view: view_name {
  suggestions: yes
}

Hierarchy

suggestions

Default Value

yes

Accepts

A Boolean (yes or no)

Definition

suggestions lets you disable suggestions for all the dimensions of type: string for a view when someone uses one of those dimensions to filter a report. (Filter suggestions work only with dimensions of type: string, so suggestions works only with dimensions of type: string.)

The default value of suggestions is yes, and suggestions are provided to the user for all dimensions of type: string when possible. If you set suggestions to no instead, suggestions will not be made.

For some dialects, such as Amazon Athena, Qubole Presto, Trino, Cloudera Impala, Apache Hive, and Apache Spark, providing suggestions requires querying the database, which may be expensive. Because of this, if you use Looker to automatically generate a project from your database for these dialects, Looker will create the views with the suggestions: no declaration.

Examples

Disable suggestions for all dimensions of type: string in the customer view:

view: customer { suggestions: no }

Things to know

suggestions at the view level works differently than suggestions at the dimension level

The suggestions parameter described on this page is applied to a view and works differently than the suggestions parameter applied to a dimension. When applied at the dimension level, suggestions lets you hardcode a list of suggestions for that dimension.

You can also simply enable or disable suggestions for a specific dimension by using the suggestable parameter.

Top