suggest_explore

LookML
Version

On this Page
Docs Menu

Go to Field Parameter List

Definition

This parameter is used with suggest_dimension to change the way that suggestions are generated for a dimension or filter field when someone uses a field to filter a report.

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 suggest_dimension you can make Looker query an alternative dimension for the suggestion values. If that dimension lives in a different explore, you specify that explore using suggest_explore. Otherwise, suggest_explore is not required.

Examples

In this example, instead of looking through a huge list of user IDs from the event table, we’ve told Looker to query the IDs from a user table instead:

- dimension: event_user_id sql: ${TABLE}.event_user_id suggest_explore: user suggest_dimension: user.id

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