Optimizing Performance of LookML Queries

In this Project, you will:

Understand when and how to add persistence and incremental updates to derived tables.

Use aggregate awareness to optimize queries on rolled up or summarized data.

Create a refinement of an existing Explore.

1 hour 30 minutes
Intermediate
No download needed
Shareable certificate
English
Desktop only

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.

Skills you will develop

  • Looker

  • Google Cloud Platform

  • LookML

  • Complex Data Queries

  • Data Analysis

How Projects work

Learn a new tool or skill in an interactive, hands-on environment

You'll gain access to software and tools in a cloud workspace - no download required

Offered by

Placeholder

Google Cloud

Frequently Asked Questions

In Projects, you'll complete an activity or scenario by following a set of instructions in an interactive hands-on environment. Projects are completed in a real cloud environment and within real instances of various products as opposed to a simulation or demo environment.

By purchasing a Project, you'll get everything you need to complete the Project including temporary access to any product required to complete the Project.

Even though Projects are technically available on mobile devices, we highly recommend that you complete Projects on a laptop or desktop only.

Yes, you can download and keep any of your created files from the Project. To do so, please make sure you save any files and work to your device before exiting the product environment.

Projects are not eligible for refunds. See our full refund policy.

Financial aid is not available for Projects.

In rare instances, Projects may be taken down for maintenance or other reasons. If you are experiencing any issues, please contact us.

Auditing is not available for Projects.

At the top of the page, you can view the experience level recommended for this Project.

Yes, everything you need to complete your Project will be available in your browser.