Applying Advanced LookML Concepts in Looker
In this quest, you will get hands-on experience applying advanced LookML concepts in Looker. You will learn how to use Liquid to customize and create dynamic dimensions and measures, create dynamic SQL derived tables and customized native derived tables, and use extends to modularize your LookML code.
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!
Getting Started with Liquid to Customize the Looker User Experience
In this lab you will use Liquid to customize dimensions and measure in Looker.
Enhancing User Interactivity in Looker with Liquid
In this lab you will use Liquid parameters and templated filters to enhance interactivity by users in Looker.
Creating dynamic SQL derived tables with LookML and Liquid
In this lab you will learn how to create and update SQL derived tables to generate dynamic values.
Answering Complex Questions Using Native Derived Tables with LookML
In this lab you will use native derived tables to answer complex questions with LookML.
Modularizing LookML Code with Extends
In this lab you will learn how to modularize LookML code with Extends.
Quest Info
Objectives
- Learn how to use Liquid to customize dimensions and measures
- Use Liquid parameters and templated filters to enhance user interactivity by creating dynamic dimensions and measures
- Understand how business users leverage dynamic SQL derived tables to answer complex questions
- Understand how business users leverage customized native derived tables to answer complex questions
- Use extends to modularize and easily reuse LookML code
Prerequisites
Familiarity with LookML is necessary. We recommend completing the Understanding LookML in Looker 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.