menu
arrow_back

Caching and Datagroups with LookML

search share Rejoindre Se connecter

Caching and Datagroups with LookML

1 heure Gratuit

GSP893

Google Cloud Self-Paced Labs

Overview

Looker is a modern data platform in Google Cloud that lets you 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.

Looker is constantly generating SQL queries and sending them to the connected database. Whenever someone runs new a query in Looker, the SQL results are cached and stored in an encrypted file on the Looker instance.

caching-overview.png

Caching leverages the saved results from previously executed queries, so that the same query does not need to be run on the database each time. This helps to reduce database load.

A datagroup is the Looker term for a caching policy or rule. LookML developers use datagroups to manage caching on a Looker instance.

Caching is a useful feature that reduces database load and helps to optimize Looker performance. In this lab, you will learn how caching works in Looker and explore how to use LookML objects called datagroups to define caching policies.

Inscrivez-vous sur Qwiklabs pour consulter le reste de cet atelier, et bien plus encore.

  • Obtenez un accès temporaire à Cloud Console.
  • Plus de 200 ateliers, du niveau débutant jusqu'au niveau expert.
  • Fractionné pour vous permettre d'apprendre à votre rythme.
Inscrivez-vous pour démarrer cet atelier