Working with Data in Explores

An Explore in Looker is a user-friendly interface that allows us to build queries against a data model without needing to write direct SQL code. Explore is the environment where users can build their visualizations based on one or multiple columns from one or multiple views (tables), applying custom filters, custom calculations, pivots, and so on if necessary. Explores are created in the model files in LookML and based on one or multiple views. Therefore, to create an Explore, you first need to define a view (or multiple views) using the view parameter. When created in a model file, an Explore can have additional configuration parameters, such as Description, Label, and Filters:

explore: users {
  # additional explore parameters go here
}

As you may remember, Looker licenses classify users into three types – Developer (Admin), Standard (Creator), Viewer. Only the first two can have access to the Explore environment. However, user...