Joining tables in models

In this section, we will work on our model file. Every LookML project can contain multiple model files if needed. Model files define Explores and their relationships to other views. Models can be placed in the Models section of the Looker IDE. The model’s name is taken from the filename and must be unique across your instance.

Getting ready

In this section, we will work on our unique lb_thelook_ecommerce.model model file.

In your LookML project in the left panel, click on models and then click on lb_thelook_ecommerce.model. Our existing model contains multiple parameters and Explores. Explores can be declared (created) based on one view or multiple views joined.

How to do it...

1. To create an Explore based on one view (for example, distrubution_centers.view), the syntax is simple:

   explore: distribution_centers {}

2. In the preceding case, the Explore name equals the base view name. In a Looker Explore, the base view is the initial data...