Looker Developer Deep Dive
LookML serves as the foundation for visualization assets in Looker and is capable of dynamic aggregations, incrementally refreshed persistent derived tables, and more. In this course, you will practice the skills to be an advanced Looker Developer through guided lectures and independent exercises using sample data.
- Duration: 2 days
- Languages: English, German
- Level: Advanced
- Group size: Up to 16
What you'll learn
- Customize and incrementally refresh SQL and native derived tables.
- Incorporate Liquid for dynamic SQL, formatting, templated filters, and parameters in Looker.
- Use extends and refinements in Looker to modularize and organize your LookML.
- Troubleshoot LookML code and improve performance.
- Apply Looker best practices to your LookML projects.
- Manage Looker deployments using DevOps practices.
- Embed Looker content into web applications.
Prerequisites
- Completion of the "Developing Data Models with LookML" course or the equivalent experience in using LookML for development in Looker.
Course outline
Looker Admin and LookML Fundamentals
- Looker Review
- Roles and User Attributes
- Connecting to a Database
- LookML Review
Diving Deeper into Derived Tables
- Understanding Derived Tables
- Adding Persistence
- Refreshing Incrementally
- PDTs and Performance
Creating Dynamic LookML with Liquid
- Core Liquid Concepts and Syntax
- Custom Links, Drills, and Formatting
- Templated Filters, Parameters and Dynamic SQL
Creating Modular LookML
- Extensions
- Refinements
- Manifests and Localization
Testing, Debugging and DevOps
- Leverage your IDE
- Debugging and Common Errors
- Data Tests
- Looker and DevOps
Looker Best Practices
- Looker Best Practices
- Improving Performance
Embedded Looker Analytics
- Explore Embedded Looker Options
- Using Private and SSO Embedding
Related courses
Data Engineering Solutions Lab (DSL)
The Data Engineering Solutions Lab (DSL) is a 10-Day, focused, immersive learning experience that rapidly upskills your team on Google Cloud data engineering principles and best practices. The program combines five days of expert-led training sessions on key data engineering concepts (e.g., data warehousing, pipelines, data quality) with hands-on labs and a five-day collaborative capstone project. The capstone challenges participants to address a real-world use case using Google Cloud tools.
Serverless Data Processing with Dataflow
This training is intended for big data practitioners who want to further their understanding of Dataflow in order to advance their data processing applications. Beginning with foundations, this training explains how Apache Beam and Dataflow work together to meet your data processing needs without the risk of vendor lock-in. The section on developing pipelines covers how you convert your business logic into data processing applications that can run on Dataflow. This training culminates with a focus on operations, which reviews the most important lessons for operating a data application on Dataflow, including monitoring, troubleshooting, testing, and reliability.
AlloyDB Essentials
This course explores the benefits of AlloyDB, especially compared to PostgreSQL on Cloud SQL. It will walk you through AlloyDB’s unique architecture, and explain how to configure deployments on Google Cloud.The course is divided into two parts: AlloyDB Administration Essentials (architecture and configuration) and AlloyDB Optimization Essentials (performance tuning).
Not sure which course fits?
Book a 30-minute call. We'll look at where your team is, what they need to be able to do, and put together either a specific course date or a tailored learning plan.