Optimizing Performance of LookML Queries
About this Course
This is a Google Cloud Self-Paced Lab. In this lab, you\'ll learn the best methods to optimize query performance in Looker. Looker is a modern data platform in Google Cloud that you can use to analyze and visualize your data interactively. You can use Looker to do in-depth data analysis, integrate insights across different data sources, build actionable data-driven workflows, and create custom data applications. Big, complex queries can be costly, and running them repeatedly strains your database, thereby reducing performance. Ideally, you want to avoid re-running massive queries if nothing has changed, and instead, append new data to existing results to reduce repetitive requests. Although there are many ways to optimize performance of LookML queries, this lab focuses on the most commonly used methods to optimize query performance in Looker: persistent derived tables, aggregate awareness, and performantly joining views.Created by: Google Cloud
Related Online Courses
The Privacy Fundamentals course introduces students to fundamental privacy concepts, frameworks and laws.\\n\\nThis specialization provides students with a foundational knowledge of important... more
Discrete Mathematics is the language of Computer Science. One needs to be fluent in it to work in many fields including data science, machine learning, and software engineering (it is not a... more
My son is going to grow up in a completely different world that is filled with generative AI (e.g., ChatGPT, Claude, LLama, etc.). I think this is a world of possibility, creativity, and deep... more
Backend refers to the server side of development. Here, the primary focus is on how a website works. Node.js is considered efficient for the development of backend applications as it brings... more
This specialization is intended for beginners to learn how to become proficient in Linux programming. It will prepare you for a role as an information technology professional by introducing you to... more