Explore Parameters
This page links to all of the LookML parameters that are children of the explore parameter.
An Explore serves as the starting point for a query in the Looker application. Explores reference views and each Explore can contain joins to other views. Explores should typically be declared in a model file.
Example Usage
Hover over a parameter name to see a quick description; click it to jump to that page.
When a parameter can be set to one of several specific options, the default value is listed first.
# STRUCTURAL PARAMETERS
explore: explore_name {
fields: [field_or_set, field_or_set, …]
# DISPLAY PARAMETERS
description: "Description I Want"
hidden: yes | no
label: "Label I Want"
group_label: "Label To Use as a Heading in the Explore Menu"
view_label: "Field Picker Heading I Want for the Explore’s Fields"
# FILTER PARAMETERS
access_filter: {
field: fully_scoped_field
user_attribute: user_attribute_name
}
# Possibly more access_filter declarations
always_filter: {
filters: {
field: field_name
value: "Looker filter expression"
}
# Possibly more filters declarations
}
case_sensitive: yes | no
conditionally_filter: {
filters: {
field: field_name
value: "Looker filter expression"
}
# Possibly more filters declarations
unless: [field_name, field_name, …]
}
sql_always_having: SQL HAVING condition ;;
sql_always_where: SQL WHERE condition ;;
# JOIN PARAMETERS always_join: [view_name, view_name, …]
join: view_name { # Desired join parameters (described on Join Parameters page) } # Possibly more join declarations # QUERY PARAMETERS cancel_grouping_fields: [fully_scoped_field, fully_scoped_field, …]
from: view_name
persist_for: "N (seconds | minutes | hours)"
persist_with: datagroup_name
required_access_grants: [access_grant_name, access_grant_name, …]
sql_table_name: table_name ;;
symmetric_aggregates: yes | no
view_name: view_name
}
explore: explore_name {
fields: [field_or_set, field_or_set, …]
# DISPLAY PARAMETERS
description: "Description I Want"
hidden: yes | no
label: "Label I Want"
group_label: "Label To Use as a Heading in the Explore Menu"
view_label: "Field Picker Heading I Want for the Explore’s Fields"
# FILTER PARAMETERS
access_filter: {
field: fully_scoped_field
user_attribute: user_attribute_name
}
# Possibly more access_filter declarations
always_filter: {
filters: {
field: field_name
value: "Looker filter expression"
}
# Possibly more filters declarations
}
case_sensitive: yes | no
conditionally_filter: {
filters: {
field: field_name
value: "Looker filter expression"
}
# Possibly more filters declarations
unless: [field_name, field_name, …]
}
sql_always_having: SQL HAVING condition ;;
sql_always_where: SQL WHERE condition ;;
# JOIN PARAMETERS always_join: [view_name, view_name, …]
join: view_name { # Desired join parameters (described on Join Parameters page) } # Possibly more join declarations # QUERY PARAMETERS cancel_grouping_fields: [fully_scoped_field, fully_scoped_field, …]
from: view_name
persist_for: "N (seconds | minutes | hours)"
persist_with: datagroup_name
required_access_grants: [access_grant_name, access_grant_name, …]
sql_table_name: table_name ;;
symmetric_aggregates: yes | no
view_name: view_name
}
Parameter Definitions
| Parameter Name | Description |
|---|---|
| Structural Parameters | |
explore (for model) |
Expose a view in the Explore menu |
fields (for explore) |
Limits the fields available in an explore from its base view and through the explore’s joins |
| Display Parameters | |
description (for explore) |
Add a description for an explore that appears to users in the UI |
hidden (for explore) |
Hide an explore from the Explore menu |
label (for explore) |
Change the way an explore appears in the Explore menu |
group_label (for explore) |
Create a label to use as a heading in the Explore menu |
view_label (for explore) |
Specify how a group of fields from the explore’s base view will be labeled in the Field Picker |
| Filter Parameters | |
access_filter |
Add user-specific filters to an explore |
always_filter |
Add filters a user can change, but not remove, to an explore |
case_sensitive (for explore) |
Specify whether filters are case sensitive for an explore |
conditionally_filter |
Add filters to an explore if a user does not add their own filter from a specific list |
sql_always_having |
Insert conditions into the query’s HAVING clause that a user cannnot change or remove for this explore |
sql_always_where |
Insert conditions into the query’s WHERE clause that a user cannnot change or remove for this explore |
| Join Parameters | |
always_join |
Specify which joins must always be applied to an explore |
join |
Join an additional view to an explore. For more information about joins and their parameters, see the Join Parameters reference page. |
| Query Parameters | |
cancel_grouping_fields |
Cancel the GROUP BY clause when certain fields are chosen in an explore |
from (for explore) |
Specify the view on which an explore will be based, and reference the fields of that view by the explore’s name |
persist_for (for explore) |
Change the cache settings for an explore |
persist_with (for explore) |
Specify the datagroup to use for the explore’s caching policy |
required_access_grants (for explore) |
ADDED6.0 Limit access to the explore to only users whose user attribute values match the access grants | sql_table_name (for explore) |
Specify the database table on which an explore will be based |
symmetric_aggregates |
Specify whether symmetric aggregates are enabled for an explore |
view_name (for explore) |
Specify the view on which an explore will be based, and reference the fields of that view by the view’s name |
| Parameters to Avoid | |
access_filter_fields |
REMOVED6.0 Replaced by access_filter |