suggestions

LookML
Version

On this Page
Docs Menu

Go to Field Parameter List

This section refers to the suggestions parameter that is part of a dimension or filter field

suggestions can also be used as part of an explore, described here

suggestions can also be used as part of a view, described here

Definition

These parameters change the way that suggestions are generated for a filter field or a dimension when someone uses that field to filter a query.

Looker typically generates these suggestions by executing a SELECT DISTINCT query on the field. For some large tables this query can be too slow or create too large of a database load.

By using suggestions you can hard-code a list of possible values instead, greatly improving performance. This parameter can also be useful if you do not want certain values from a field to appear as suggestions, by specifying a more limited list.

Examples

Replace the default suggestions for the Colors dimension with a hard-coded list:

- dimension: colors sql: ${TABLE}.colors suggestions: ['red','yellow','blue']

Still have questions?
Go to Discourse - or - Email Support
Top