Working with dynamic SQL

The SQL parameter supports a variety of SQL expressions that serve the purpose of defining dimensions, measures, and filters. We already explored it earlier in this book. Now, let’s discuss how we can use Liquid variables in SQL parameters.

It is worth mentioning, in this chapter, the parameter element in Looker. It creates a filter-only field that can be used to filter Explores, Looks, and dashboards. It cannot be added to a result set:

view: view_name {
  parameter: parameter_name { ... }
}

We will use this parameter element in this recipe.

Getting ready

In this section, we will work in multiple environments: LookML to create the SQL parameter(s) and Explore to build a Look with the dimension or measure that contains this parameter. We’ll start with the LookML project. If you’re on the Looker home page, find the Develop tab (usually in the menu on your left), click on it, and then click on Projects. On the LookML...