Understanding LookML in Looker

5 hours Introductory 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.

Badge for Understanding LookML in Looker

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.