Great Use Cases for Parameter Fields

The Looker parameter field lets you inject a value directly into the SQL.

Various Looker pages describe how to use this feature:

• The Templated filters and parameters documentation page, which discusses creating the field and applying the user input
• The parameter reference page for this field type and its allowed_value subparameter
• The Field parameters page, which includes the parameter field type and shows which LookML parameters can be subparameters of the parameter field
• The Liquid variable reference documentation page, which mentions the {% parameter %} Liquid variable
• The Dimension, filter, and parameter types documentation page, which indicates the LookML type parameter values that can be used with parameter fields

The following use cases and examples formerly discussed on this page have been relocated to the Looker documentation and Community:

1. Creating dynamic dimensions and measures— Inserting user-selected values with {% parameter parameter_name %}
2. Multiple schemas with the same data format— Dynamic schemas with the same data format using parameter
3. Top N items versus the rest of the population — Using parameters to find the top N items versus the rest of the population