arrow_back

Understanding LookML in Looker

share

Understanding LookML in Looker

5 hours Fundamental universal_currency_alt Free
In this quest, you will get hands-on experience with LookML in Looker. You will learn how to write LookML code to create new dimensions and measures, create derived tables and join them to Explores, filter Explores, and define caching policies in LookML.

Complete this activity and earn a badge! Boost your cloud career by showing the world the skills you’ve developed.

  • Lab

    Looker Developer - Qwik Start

    In this lab, you will learn about the fundamental LookML structures, create a view, and join the new view to an existing explore.

  • Lab

    Creating Measures and Dimensions Using LookML

    In this lab, you will build dimensions and measures and practice these features in LookML to learn different types of dimensions and measures Looker supports.

  • Lab

    Creating Derived Tables Using LookML

    In this lab, you create SQL derived and native derived tables in LookML to define new tables that do not already exist in the underlying database.

  • Lab

    Filtering Explores with LookML

    In this lab, you will learn how to filter explores with LookML

  • Lab

    Caching and Datagroups with LookML

    In this lab, you will learn how caching works in Looker and explore how to use LookML objects called datagroups to define caching policies.

  • info
    Quest Info
    Objectives
    • Define, read, and write LookML
    • Create and use different types of dimensions and measures in LookML
    • Create derived tables and join them to Explores
    • Use and understand the different types Explore filters
    • Use caching policies and datagroups
    Prerequisites
    Familiarity with Looker is necessary. We recommend completing the Exploring Data with Looker skill badge quest before beginning.