This page links to all 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 { extension : required extends : [ explore_name , explore_name , ... ] fields : [ field_or_set , field_or_set , ... ] tags : [ "string1", "string2", ... ] # DISPLAY PARAMETERS description : "Description I want" group_label : "Label to use as a heading in the Explore menu" hidden : yes | no label : "desired label" query : { # Desired query parameters (described on the query page) } 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_name : "filter expression" , field_name : "filter expression" , ... ] } case_sensitive : yes | no conditionally_filter : { filters : [ field_name : "filter expression" , field_name : "filter expression" , ... ] 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 ;; sql_preamble : SQL STATEMENT ;; symmetric_aggregates : yes | no view_name : view_name # AGGREGATE TABLE PARAMETERS aggregate_table : table_name { query : { # Desired query parameters (described on the aggregate_table page) } materialization : { # Desired materialization parameters (described on the aggregate_table page) } } # Possibly more aggregate_table declarations } ## REFINEMENT PARAMETERS explore : + explore_name { final : yes }
Parameter definitions
Parameter Name
Description
Structural Parameters
Specifies Explore(s) that will be extended by this Explore
Specifies that the Explore requires extension and cannot itself be exposed to users
Exposes a view in the Explore menu
Limits the fields available in an Explore from its base view and through the Explore's joins
Specifies text that can be passed to other applications
Display Parameters
Adds a description for an Explore that appears to users in the UI
Creates a group label to use as a heading in the Explore menu
Hides an Explore from the Explore menu
Changes the way an Explore appears in the Explore menu
Creates a predefined query for users to select in an Explore's Quick Start menu.
Specifies how a group of fields from the Explore's base view will be labeled in the field picker
Filter Parameters
Adds user-specific filters to an Explore
Adds filters a user can change, but not remove, to an Explore
Specifies whether filters are case-sensitive for an Explore
Adds filters to an Explore if a user does not add their own filter from a specific list
Inserts conditions into the query's
HAVING
clause that a user cannot change or remove for this ExploreInserts conditions into the query's
WHERE
clause that a user cannot change or remove for this ExploreJoin Parameters
Specifies which joins must always be applied to an Explore
Joins an additional view to an Explore. For more information about joins and their parameters, see the Join Parameters
reference page.
Query Parameters
Cancels the
GROUP BY
clause when certain fields are chosen in an ExploreSpecifies the view on which an Explore will be based, and reference the fields of that view by the Explore's name
Changes the cache settings for an Explore
Specifies the datagroup to use for the Explore's caching policy
Limits access to the Explore to only users whose user attribute values match the access grants
Specifies the database table on which an Explore will be based
Specifies whether symmetric aggregates are enabled for an Explore
Specifies the view on which an Explore will be based, and references the fields of that view by the view's name
Aggregate Table Parameters
Creates an aggregate table in order to use aggregate awareness for queries on the Explore. For information on the
aggregate_table
parameter, see the aggregate_table
parameter page. For an overview of aggregate awareness, see the Aggregate awareness
documentation page.Defines the query for the aggregate table. For information on
query
and its subparameters, see the aggregate_table
parameter page.Defines the persistence strategy for the aggregate table. For information on
materialization
and its subparameters, see the aggregate_table
parameter page.Refinement Parameters
Adds a plus sign (
+
) in front of an existing Explore name to add a refinement to the existing Explore. See the LookML refinements
documentation page for more information and use cases.Indicates that the current refinement is the final refinement allowed for the Explore. See the LookML refinements
documentation page for more information and use cases.
Parameters to Avoid
access_filter_fields
