menu

Understanding LookML in Looker

Fundamental 5 个步骤 5 个小时 免费

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.

预备知识:

Familiarity with Looker is necessary. We recommend completing the Exploring Data with Looker skill badge quest before beginning.

目标:

  • 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

Quest Outline

实验

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.

实验

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.

实验

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.

实验

Filtering Explores with LookML

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

实验

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.

立即注册

注册该挑战任务,系统会全程跟踪进度,直到您赢得徽章为止。