Google Cloud Skills Boost

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.

When you complete this activity, you can earn the badge displayed above! View all the badges you have earned by visiting your profile page. Boost your cloud career by showing the world the skills you have 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.
    Available languages
    English
    What do I do when I finish this quest?
    After finishing this quest, you can explore additional content in your learning path or browse the learning catalog.
    What badges can I earn?
    Upon finishing a quest, you will earn a badge of completion. Some quests test your ability to apply your knowledge via a final assessment challenge lab. For these quests, you will receive a skill badge. Badges can be viewed on your profile and shared with your social network.