Skip to content
BENIBIX Learn

Looker

Also known as Google Looker, Looker (Google Cloud core)

A Google BI tool. Data is set out once in code, then all can explore it.

Think of it like

It is like one recipe book that all the cooks must use. The dish tastes the same, no matter who cooks.

Example

A shop chain writes its revenue rule once in LookML. Now each chart in Looker uses that one rule.

Why it matters

When the numbers live in code, they can be checked and kept in Git. They are looked after like any other code.

Definition

Looker is a BI tool from Google Cloud built around a semantic layer. Data teams describe the data once in code, in a language called LookML. Business users then explore and build dashboards from those shared definitions. Looker sends SQL to the warehouse each time and does not keep its own copy of the data. Google bought Looker in 2020.
In Looker, the middle box is written in LookML. Every chart reads from it.

Common mistake

Treating it as a drag and drop tool and skipping the model. Without good LookML, users have little to explore.

Key takeaways

  1. 1
    Model first. Data is described in LookML.
  2. 2
    Live queries. SQL runs in the warehouse each time.
  3. 3
    Shared definitions. Every chart uses the same rules.

Compare